OLAP tool convert to formula not returnin same number as in Pivot

Patricia Flores 1 Reputation point
2022-08-23T15:19:00.567+00:00

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
SQL Server | Other
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.