I have a set of several sheets for different metrics with multi-year tables of data where columns are for months because there's 15k+ rows of products, which are always in the same order throughout all the metrics' sheets (same with dates, ofc). I'd like to be able to present the data through several pivot charts all dependent on one pivot table where I can have 1 slicer for months+another for weeks if they're the date attribute used and 1 slicer for the different metrics (amount of buyers, revenue, net revenue, etc); extra points, there's a combined product category which is always the top ranked, I'd love to have a slicer for "with" "without" combined product if possible.
I'd imagine having both Months and Weeks would be ideal, but that would complicate things a bit further (?) as the same month value reaps for every ~4 weeks, but it'd be great to slice through either attribute.
Any comment, observations or collab would be greatly appreciated
Note: this has also been posted on StackOverflow
Bookmarks