I have to build a report where my cube structure is ( day, measure, location, SO Number, Store, Customer, Item). I am using day, location, customer selection as combo box and I want that based on selected date, I should have all the SO number (Sales orders) as a dynarange, then there are various stores too, so every SO should have Stores below it and then after, items for that particular store.
I can get SO Number and item below it or store and item below it but I am unable to get the view I want, that all three co-related.
Below is the attached view that I need.
I read that 3 vertical dynaranges is not possible but how can I achieve this view.
Thanks