I created a pivot table and did not import it into the data model. Later I needed to recreate the pivot table with it in the data model due to multiple data sources added from queries. The total percentages column calculates correctly when using a calculated field while not in the data model but adds the percentages together when the calculated column is added in the data model. How do I fix this?
No OLAP.png
OLAP.png
Bookmarks