1 Reply Latest reply on Dec 7, 2018 5:06 AM by Patrick Van Der Hyde

    Fixing the dimension


      Hi all,

      Suppose I have a requirement of Fortis and top 5 competitors in the market on the basis of volume.

      Next I have to show a trend on the basis of Region/ Customers.


      My approach:

      Creating two sheets.

      In first, Cipla is constant and will show the trend price; filters: Region, Customers, Timeline(Year wise/Month wise/Qtr wise)

      In Second, top 5 competitors on the basis of volume and will show the trend on the basis of price; filters: Region, Customers, Timeline, Competitors(A/B/C/D/E)


      1) Can you suggest any better way

      2) What should I do, if I want to show them in the same sheet?


      Thank you.