Show percentage based on First value instead of previous

Shahista

New member
Joined
Feb 11, 2017
Messages
1
Reaction score
0
Points
0
Hi,

I have pivot table and pivot chart for the same table.

Table has 6 columns as mentioned in the attached file.

Pivot table is generated with 2 columns and the rows are grouped based on requirement.

When i see the values in the pivot table its perfectly fine but when I try to see in percentage I don't see any option to see the percentage based on first value instead of the previous.

The logic should work even if the user group the pivot table.

Please find attachment for the expected result.

Can anybody help me in resolving the issue?


Thanks in advance.
 

Attachments

  • ExampleFile.xlsx
    13.3 KB · Views: 14
Back
Top