on 03-10-2021 3:56 AM
Hello Experts,
I am trying to replicate a BW report. Report structure looks like below:
I am trying to created calculation between dimensions on column and version and date in rows.
Similar to BW setup, we tried to add formulas at the table cell level. Issue is that every time input control on PC or CC or Year changes, formulas stops working.
I tried to use calculated measure, seems like I am not able to get the desired results when with dimensions in rows and column both. Kind of cross cell calculation.
I tried cross calculation, though unable to combine version with account dimensions. All I see is measures (Amount field) from account dimensions under formal.
I have seen this setup in multiple demos from SAP. So I am certain it is possible. Not sure though how to do it.
Thanks.
Hello viraj_saha,
You can use "Cross Calculation" for your setup. In-fact cross calculations are built for such requirements. Here is an example similar to yours. Adding Forecast and Actuals by Product Type. You can use budget with actuals in your case.
I have seen similar query recently from others.
This is how the final output would look like. You can switch rows and columns as pre your requirement. Steps below would give you some idea on how to use cross calculations
Steps-
Hope this helps. Let us know if you have any query around this topic.
Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).
- Debjit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.