Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Wrong Calculation in Crosstab

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

Not what you were looking for? View more on this topic or Ask a question