Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot chart which has the following:
1 2 3 …
Shehan 975 1050 1102
James 950 1175 1101
Stewart 1105 980 985
Emmett 1000 1005 975
I need a fourth column where it looks and counts the number of values which exceed 1000.
1 2 3 … overages
Shehan 975 1050 1102 1
James 950 1175 1101 2
Stewart 1105 980 985 1
Emmett 1000 1005 975 0
Hi,
See the attached sample file i think you use like this see the fourth expression overages in the pivot table on the Solution sheet
See the attached sample.
Regards,
Anand
Hi,
See the attached sample file i think you use like this see the fourth expression overages in the pivot table on the Solution sheet
See the attached sample.
Regards,
Anand