Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It is possible by using conditional expression for Value, where condition is based on dimensionality() - see attached.
It is possible by using conditional expression for Value, where condition is based on dimensionality() - see attached.
Michael that worked perfectly. Many thanks!