I have a question i am having a tough time figuring out the answer to..
Basically what i want to do is this. Suppose i have product sales at a monthly-store level like below. And i have a bunch of auxilary store measures like Squarefootage, what type of store, who is store manager etc..
Basically what i want to do is, when someone clicks on a Product from a filter, i need to know share of Sales for that product in that product type for the selected time period... More like market share for my Product, in example below, for selected time period (Month #1), My brand share is 20% , as my share is 20 / (20 + 30 + 50) for Product Type Apparel...(so i will want this # to be updated dynamically for any combination of filters the users may apply)
Please let me know and i will be forever grateful!
Product - Store - Sales - Month - Product Type - Brand