-
Re: Numbers don't stay consistent in pivot table
Hi,
this really depends on your expressions and chart settings. Can you post your expression?
Juraj
-
-
Re: Numbers don't stay consistent in pivot table
OK. I don't think you EVER want to do Sum(DISTINCT NetSales). Leave that distinct out, your numbers will not change.
-
-
Re: Numbers don't stay consistent in pivot table
I think it's because my data has some null customers with net sales. When the pivot table closes, the numbers include those net sales. But when it expands, the pivot table won't include them. How can I fix it?
-
Re: Numbers don't stay consistent in pivot table
Did you uncheck "Include null values" on the customer dimension? It should be checked if you want to include those customers.
-
Re: Numbers don't stay consistent in pivot table
I unchecked them. I don't want them to show, but when pivot table is closed, the numbers still include those net sales.
-
Re: Numbers don't stay consistent in pivot table
OK, then you can try
SUM({<SalesRep*={"*"}, Customer*={"*"}>}Aggr(SUM({<SalesRep*={"*"}, Customer*={"*"}>} NetSales), [OrderNo]))
Although I think you should be perfectly ok with a simple
Sum(NetSales)
-
-
-
-
-
-
-
Re: Numbers don't stay consistent in pivot table
Hi there,
not sure what exactly you mean by "numbers change", however I did come across an issue whit high resolution numbers changing digits within decimal points in some of my pivots when I was expanding the dimensions. This could be the case here too. To stabilize your results you can either set a specific format in settings of your pivot table or you could use num() within your load script to always use the same format for your net sales.
I hope this helps!
Michalina
-
-
Re: Numbers don't stay consistent in pivot table
I think it's because my data has some null customers with net sales. When the pivot table closes, the numbers include those net sales. But when it expands, the pivot table won't include them. How can I fix it?
-
-
