PDA

View Full Version : Show percentage based on First value instead of previous



Shahista
2017-02-11, 10:39 AM
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.