1. Just go through the scenario

·         If we have 3 dimensions (Year,State  and City) and 1 Measure (Sales revenue) in query

·         In croostab we are displaying measure for state and Year only like,

·         If I want to add 100 with existing measure and display in next column like

·         The problem is it is not adding 100 to state’s aggregated measure, If there are 5 cities under a state then 500 is added (in each city’s revenue 100 is added then aggregating state’s revenue) and displaying wrong result