There is no way to show a row that does not exist. I do have a suggestion. Instead of changing the filter, add the criteria to the data definition of the fact items.
If you want all rows for xyz with fact 'Amount', but are filtering for x then add the criteria in the data definition-
if(row...
You can not remove the groupings, but you can populate each row by putting a 1xn table in the lowest group level (customer) and place the crosstab groupings in the table cells.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.