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.
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?
Retrieving data ...