[Pivot] Retrieve Data

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top