This is a total noob question I'm sure. I'm just getting started and this is my first time creating something in powerpivot. (I've used tools created by others in the past). I'm trying to build a dashboard with several charts and slicers.
I'm creating a POS report for a manufacturer taking several POS feeds from major retailers and linking the retailer's item numbers (this is how they report) to the manufacturer's number via a cross reference table. I'm able to get the sales to roll up to the manufacturer item number, but as three seperate measures (POS Qty), with a bar for each item. How do I get the POS qty's from each retailer to show as one number, then use the slicers to select individual retailers? Also, if I wanted to show a total topline trend, rolling all sales of all items into one monthly number how would I do that?
Thanks,
gh
I'm creating a POS report for a manufacturer taking several POS feeds from major retailers and linking the retailer's item numbers (this is how they report) to the manufacturer's number via a cross reference table. I'm able to get the sales to roll up to the manufacturer item number, but as three seperate measures (POS Qty), with a bar for each item. How do I get the POS qty's from each retailer to show as one number, then use the slicers to select individual retailers? Also, if I wanted to show a total topline trend, rolling all sales of all items into one monthly number how would I do that?
Thanks,
gh