Count as Partial sum in Pivot Chart under a Dimension

[#1]

Hi,

Not sure this is possible but thought I would ask the question.

I have a pivot chart where the year split is important.  I simply would like to count the number of 'Yes' values (essentially all rows) by year and display the count in the 'Value' column.

Year	DimensionA	Value
2013	A	Yes
	B	Yes
	Total	2
2014	A	Yes
	B	Yes
	C	Yes
	D	Yes
	E	Yes
	F	Yes
	Total	6
Total		8

is this possible?

Thanks.

[Anonymous · Accepted solution]

It is possible by using conditional expression for Value, where condition is based on dimensionality() - see attached.

[#3]

Michael that worked perfectly.  Many thanks!