1 of 1 people found this helpful
your data is sparse - that is it has missing data in the table - you will need to pad that table to fill in the blanks
HOF Jonathan Drummey wrote a 2 part series on this issue - the link below will take you to the first - then you can go on to the second
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Norbert ,
Worked like a charm I am doing other way round using the partition at year level but at the level does the job thanks a lot for quick solution
Link you provided gives much info about table calc thanks for link and always admire your quick answers thanks a lot for helping
Here is "why" part.
When you put dimension on table this way, it automatically generate "8" with same table calc setting.
But same Table down on year and state,need to set manually.
Dynamic Trellis Chart_SM_10.5.twbx 399.9 KB
You are welcome. Thanks for the "Badge". Much appreciated