Would switching first two column order help?
Also, I think you can create hierarchy from these two as well.
Thank you for your response:
I attempted to do that however, it returns the below. I am trying to derive count of Jrnal No that fall in the bins i.e. count of Jrnal No with Jnl Line in the 601 - 800 bin, 801 -1000 bin and so on.
If I remove Jrnl No dimension, everything is classified in the 1000+ lines bin.
Any help would be appreciated.
1 of 1 people found this helpful
I had a quick crack with LOD expressions but i think because the LOD you are after if more fine than the view it wasn't working.
However I did find that allocating the Journal No to detail seemed to give you the result you were after. But I did make a pretty small data set so it could have been a fluke.
Logically i think this retains the finer level of detail you were after but without actually displaying the Journal No's.