Just go through the scenario
u2022 If we have 3 dimensions (Year,State and City) and 1 Measure (Sales revenue) in query
u2022 In croostab we are displaying measure for state and Year only (State in columns and Year in Top Row)
Year
State Measure
u2022 If I want to add 100 with existing measure and display in next column like
Year
State Measure Measure+100
u2022 The problem is, it is not adding 100 to stateu2019s aggregated measure, If there are 5 cities under a state then 500 is added (in each cityu2019s revenue 100 is added then aggregating stateu2019s revenue even if we are not including the city in report) and displaying wrong result
Any Idea how to resolve this issue?
Thanks in Anticipation