Hi All,
How to get count of dimension for each value
example
I have supplier name as Dimension and count of value as measure
from this I need each measure the count of supplier name
O/P should be
1 count(supplier) - Under value 1 how many supplier
2 Count(supplier) - Under value 2 how many supplier
3 COnt(supplier) - Under value 3 how many supplier
..
so on
thanks
hi shanmuga,
So from my understanding you want to "group" the suppliers into bins, of 1 count, 2 count, 3 count ...etc.
One way, and probably the easiest, is to use a FIXED LoD
Create a calculated field, something like
{FIXED [Supplier]: COUNT([the thing you are counting]}
bring this onto the dimension pane, as we'll be using it like a dimension
Now drag this field onto the Column Shelf, and drag [supplier] onto the rows. Drag supplier with the right mouse button and you should get some options when you drop it. Select COUNTD and that should do it. You can, of course, switch the Column/Rows around depending on your preference.
Hope that helps
