if i want to show a 0 subtot
for example if i have 2 filter one called cake and the other one called coffee i have 0 cake and 2 coffee so my pivot table is showing me
only the coffee filter with 2
is it possible to add a rule to return me always the 2 filters even if one of them or both have got 0 tot?
better explain my report won't show the world cake or coffee if they have 0 tot.
so i need to have set in stone the 2 filters...
i guess i need to add and extra bit overwriting the principple of pivot table as this just shows subt of what we have...
for example if i have 2 filter one called cake and the other one called coffee i have 0 cake and 2 coffee so my pivot table is showing me
only the coffee filter with 2
is it possible to add a rule to return me always the 2 filters even if one of them or both have got 0 tot?
better explain my report won't show the world cake or coffee if they have 0 tot.
so i need to have set in stone the 2 filters...
i guess i need to add and extra bit overwriting the principple of pivot table as this just shows subt of what we have...
Last edited:
