Skip to Content
0
Former Member
Sep 17, 2008 at 12:09 PM

Wrong Calculation in Crosstab

34 Views

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