Forum Discussion
Advocate IIINon-aggregated matrix?
Ok - so I have an Income Statement I am trying to build. The data comes in from Snowflake, where all of the calculations are already done, including all the aggregations. Here is what I would like to do: have a hierarchy, but just display the values - no calculations. Everything I've tried so far does not work. So, in the sample data, all of the B items add up to the A, but that A value is already calculated in Snowflake.
| CURRENT | PREVIOUS | BUDGET | |
| A | 1000 | 2000 | 1500 |
| B | 250 | 500 | 375 |
| B | 250 | 500 | 375 |
| B | 250 | 500 | 375 |
| B | 250 | 500 | 375 |
Hi rmcgrath
Please try inscope function.
refer attached file for reference.
Please give kudos or mark it as solution once confirmed.
Regards,
Praful
3 Replies
rmcgrathUPDATE: I found one of the Custom Visuals called "Summary Table", which is awesome and SO close to what I need, but it does not support collapsing (as in my Sample data above: collapsing all the B items under A)
- danextian
Super User
Hi rmcgrath
You can create a conditional measure to return a different value when A is the current hierarchy and B isn't. If A is already computed perhaps, you can simply return the max value of A if it keeps repeating. Otherwise, please provide a workable sample raw data (not an image) and your expected result from the same.
- Praful_Potphode
Hi rmcgrath
Please try inscope function.
refer attached file for reference.
Please give kudos or mark it as solution once confirmed.
Regards,
Praful
