Hi Folks,
Thanks for looking into my question.
I am trying to apply top 10 filter on a pivot which has a nested data. I want the same filter to be applied to data at previous hierarchical level too.
In the attached file, I am trying to find the sales are profit for
Each region aand group id but only where run_id is minimum.
Example the pivot should display
East ---- 1123 ------ 12 ---------------3434 ----------- 858.5
---- 1243 ------- 43 --------------1300 ----------- 260
East total
West ----- 1123------- 11 -------------- 34243 ------ 6848.6
------1129 ------32 --------------- 5467 -------- 1366.75
Please help...My job depends on this
Thanks in advance.
Bookmarks