I'm trying to create multi-level pivot table on benefit_plan table to the format as below*
Tried inserting the required fields in column but it doesn't show as the table above.
Wanted to explore multiple data sets to construct this table, but don't think multiple data sets is allows for multi-level pivot table. Any idea on how to construct the table above? Without coding required?Thanks
You can use Performance Analytics Breakdown widget with pivot scorecard visualization. It will be displayed something like below:
Dashboard filter can be put for Fiscal period using breakdown dashboard.
