OLAP tool convert to formula not returnin same number as in Pivot
Patricia Flores
1
Reputation point
hi everyone,
I have a SASS cube conected to a PowerPivot and I use the OLAP tool to convert to formulas.
I have a field in SOLD PARENT ACCOUNT where I have 40 retail stores and I am filtering to get only the sum of 2 of all the stores.
The pivot gives me the right total for my measure but when I use OLAP get the formula for only these 2 stores I get the sales total of the 40 of them.
It seems as if the convert to formula function is ignoring my filter.
233842-image.png
233843-image.png
any idea what's the problem and how to fix it?
Microsoft 365 and Office | Excel | For business | Windows
3,895 questions
SQL Server | Other
14,494 questions
Sign in to answer