• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Powerview / Powerpivot: calculate marketshare

Amnesiac

New Member
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:

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            1
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!
 
Back
Top