Hi, was wondering if its possible to make my pivot table appear as attached. I have 4 column, one is Name, one is Type , one is Amt, one is Deposit. However, for my Deposit, i am unable to make it appear as one single column.
Is there a way to solve?
Yes, you can load the data into the data model and then create measures for each - see attached example.
Rory
Thanks Rorya, errrrrr... how u do? Is it u create 1 pivot table 1st den click on the "Add to data model"?
You could use formulas too.
Formula:
Please Login or Register to view this content.
WoW Djun, thats impressive! Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks