Show / Hide Negative and Positive Values in Pivot Table Row

[eng19872]

Hi,

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.

Filter Negative Values
Current Output
Dim 1	Dim 2	Months
		Total Column	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12
Region 1	Area 1	-36	1	2	3	4	5	6	-7	-8	-9	-10	-11	-12
Region 1	Area 2	36	-1	-2	-3	-4	-5	-6	7	8	9	10	11	12
Required - Output if Total is Negative
Dim 1	Dim 2	Months
		Total	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12
Region 1	Area 1	-36	1	2	3	4	5	6	-7	-8	-9	-10	-11	-12
Required - Output if Total is Positive
Dim 1	Dim 2	Months
		Total	M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12
Region 1	Area 2	36	-1	-2	-3	-4	-5	-6	7	8	9	10	11	12

[shiveshsingh]

Hi

Why don't you try with enable condition during defining Dimensions?

Just give it a try

[eng19872]

Hi,

Conditional Show / Hide is not a problem, but the problem is to show only Negative Values.

Example:

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.

Thanks,

[shiveshsingh]

Can you share input file? 

[eng19872]

Current output and required output is given in attached file.