0 Replies Latest reply on Oct 28, 2018 11:48 PM by KHARANSU RATH

    Fixing the dimension

    KHARANSU RATH

      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.