Totals in pivot table

Fri, 24 Oct 2014 11:14:18 GMT

Hi All,

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.

Any help would be appreciated.

Thanks,

Laura

topic Totals in pivot table in QlikView

Totals in pivot table