Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve Data to Pivot Table "On Demand" | Excel Worksheet Functions | |||
Retrieve whole row of data | Excel Worksheet Functions | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
How to retrieve data from web? | Excel Programming |