3 vertical dynaranges or suggestion for attached view

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • 3 vertical dynaranges or suggestion for attached view

    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
    Files
    • 3 dynaranges.PNG

      (10.31 kB, downloaded 105 times, last: )