Hi Team,
In my attached workbook I have three view in Dashboard.
But I have some challenges here listed
1) View 1 has Dimention has Hierachy, so user can expand and collpase from Region to State and City.
But If they do so Above text boxes that is created to group the measures are getting disaligned.
Example Group A Box should be on top of #Orders, #People and #Returns
Group B box on top of Discount and Profit
Group C Box on Top of Profit Ratio, Quantity, Sales
At first level this alignment correct, but if user expand to Region->State-> then it get disalligned.
Any workaround for this?
2) With expand and collapse below table measures also getting disaligned, example #Orders should be in one line for all the tables,
#People should be in one line for all the views etc. But everything getting disalinged when we expand or collpase. Any workaround for this?
Hi Nilanjan,
With Drill down on one view and with static dimension on the below view, it is not possible to have the alignment of the measures on the dashboard or of the text boxes.
One work around I got is, on the first dashboard, we can have text boxes and measure names aligned on both the views. And, we can have an action on sheet 1 on select to pass it to the detailed view with drilled down values
Regards,
