S
Sphenix
I need help on how to get the data for each pivot tables fields. I try
some way with the pivot item and some pivotfields value which is not
what i want because the data already distinct.
example
Curr_ID, Branch_ID, Amount
USD, 100, 100
, 100, 200
SGD, 101, 100
what i want is,
i need to do the listing reports,
which from the pivot table with result like below
USD, 100, 100
USD, 100, 200
SGD, 101, 100
but i cant , because i the only get the value USD once and SGD once
only, I cant get USD twice...
some way with the pivot item and some pivotfields value which is not
what i want because the data already distinct.
example
Curr_ID, Branch_ID, Amount
USD, 100, 100
, 100, 200
SGD, 101, 100
what i want is,
i need to do the listing reports,
which from the pivot table with result like below
USD, 100, 100
USD, 100, 200
SGD, 101, 100
but i cant , because i the only get the value USD once and SGD once
only, I cant get USD twice...