Show / Hide Negative and Positive Values in Pivot Table Row
I have given below "Current Output" and now I would like to make change.
I have filter called "Negative Values". When I make selection in filter Negative Value then the row Negative Value will show where the total is in negative otherwise positive row will show and come always if filter is not selected.
Current and required outputs are also given below, however I am attaching the data source file with scenario.
Re: Show / Hide Negative and Positive Values in Pivot Table Row
Conditional Show / Hide is not a problem, but the problem is to show only Negative Values.
Total Value is in Negative, then when I make expression on the behalf of total then only negative value appear in whole row so How to show positive values as well in the same row when filter Negative Value is selected.
Please have a look into the excel file for current and required output.