1 of 1 people found this helpful
There are a lot of different routes we can go when tackling sales analysis over time. Do you have any additional detailed information on the requirements for your project? Providing us with the specifics, such as the exact values you are expecting to see, or the exact structure you need the viz to be in, will help quite a bit when we're attempting to assist in building out the visualizations
I'm not entirely sure what you mean by Market Share. Are you going for a Percent of Total? One option would be to make something like the following where I added a quick table calculation (Percent of Total) and computed the calc using Table Down. This gives us the percentage values for each member in the Prod dimension for each date.
I'm a bit too late in replying to you
Your method really helped.
What I also tried to do was to use the date functions and Fixed functions to get this as calculated fields itself. This way I could avoid the Table calculations and also use these calculated fields for more calculations.