Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I got a pivot table in which the dimension is a column from a parent table and the expressions are from the child table
not all the columns of the parent table have related values in the child table (per year)
what I want is display all existing values of the dimension column even if there is no data in the child table
kind of a left join but without really making a left join
is this possible?
You can play with some chart properties:
- at the dimensions tab: use the show all values
- at the presentation tab uncheck supress zero-values
Hope this helps,
Erich