[Pivot] Retrieve Data
 

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...