Hi all,
At the moment I am working with powerpivot and poweview to create an marketshare dashboard for my organization. All my data is structured in one single table with the following design:
etc......
I would like to create a view in powerview where i see my marketshare tracked over the weeks with the product category as a filter. Is this at all possible?
Normaly I would use an regular pivot table with an calculated item and a slicer to accomplish this but the amount of data is to large for a regular pivot table.
Any help would be much appreciated!
At the moment I am working with powerpivot and poweview to create an marketshare dashboard for my organization. All my data is structured in one single table with the following design:
Code:
Date Reportingchannel Sales EUR Sales pieces product_category
1/1/2015 My_organization 25 5 1
1/1/2015 online market 100 20 1
1/1/2015 offline market 200 50 1
8/1/2015 My_organization 25 5 1
8/1/2015 online market 100 20 1
8/1/2015 offline market 200 50 1I would like to create a view in powerview where i see my marketshare tracked over the weeks with the product category as a filter. Is this at all possible?
Normaly I would use an regular pivot table with an calculated item and a slicer to accomplish this but the amount of data is to large for a regular pivot table.
Any help would be much appreciated!