Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a few tables (pivoting and simple) in showing the client and family, but when I selected the month in which no sale to a customer or a family disappear records. How could I do to not disappear?
Thanks and best regards
Did you try the "Show all values" setting on your dimension tab?
Or the the "Supress Zero-values" setting on the Presentation tab?
Maybe one of those settings gives you the result you need.
hey gabrial
can u send me ur file plz
thanks
rohit
I'm sorry, too many confidential data on the application
i Don't knw if i understood ur problem properly or not. but u can try this.
Add an expression : 1
Then u vil be able to see all the records.
or scramble ur cofidential field and then upload ur file.
May be then v can help.
Did you try the "Show all values" setting on your dimension tab?
Or the the "Supress Zero-values" setting on the Presentation tab?
Maybe one of those settings gives you the result you need.
Thanks for your reply Erika, but I've got, properties, dimension, check box to display allvalues. The only flaw is that in a pivot table all values are 0 sales to the nest in a null field(-) rather than in the corresponding family.
I tried your solution, add a new expression in the editor type 1, but does not work.
regards