I have a pivot table chart which has 3 dimensions. (country. business, name)
i want to only show data which is not equal to yes in 5 indiviudal field expressions.
which creates the following correct chart:
Country
Busienss
Name
fielda
fieldb
fieldc
fieldd
UK
UKA
A
NO
N/A
NO
UK
UKA
B
NO
UK
UKB
ABC
NO
<not declared>
FRANCE
FRANCEA
DEF
NO
GERMANY
GERMANYA
GHY
NO
NO
NO
NO
GERMANY
GERMANYB
GERW
NO
As this is a pivot table when it is collapsed i want it to count the total number of rows with data in for that country
So the above table collapsed would look like
Country
Busienss
Name
fielda
fieldb
fieldc
fieldd
UK
UKA
A
2
1
2
1
FRANCE
FRANCEA
DEF
1
GERMANY
GERMANYA
GHY
1
1
2
1
I do not know how to get the table to look like the above collapsed as the data is not numeric and the total part on the expression in properties is greyed out.
