Forum Discussion
Custom Subtotal/Grouping in Inforiver Reporting Matrix Based on Flat Data Table
Hi Everyone, I am trying to create a custom subtotal/grouping in the Inforiver Reporting Matrix based on a flat data table. Below is an example of my data model and the desired outcome. For simpl...
Hi gordoncappo
My suggestion is to change your table structure so that different levels of 'sales unit' are placed in different columns, rather than in the same column.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thank you for taking the time to review my post—I appreciate it.
In reality, my data model follows a properly structured star schema. However, my sales data (i.e., the 'Data Model' grid above) is loaded into the system in this format, so I cannot change its structure. If I’m misunderstanding you, could you clarify your suggested method?
Thank you.
- GC