i have a issue database where i want to do the following in qv
I have 4 tables:
now i have a pivot table and what i want to do is show alle values of status even if the project contains not all the status values.
is this possible?
if yes, how can i do it?
You can do it by checking show all values in dimension Tab
thought so too, but for a dimension on the x as it works.... however a dimension on the y as I don't get it to work
Did you try the "Show All Values" options in the Dimension tab?
Also uncheck the "Supress Zero-values" option on the Presentation tab.
In continuation to Dennis also check populate missing.
I tried it,but no help.
Can you please share the pivot table
Please attach a sample QVW of the chart and data you are working, to make it easier to evaluate and advise on.
Retrieving data ...