I am doing some analysis for a company that sells take away food. They are running various trails on different groups of products. I have set up a disconnected slicer with the name of the trial and the date when the trial started e.g.
Bread trail 7/9/15
This works great as i select the trial name and then can feed the date into various formulae to calculate the transactions 4 weeks before and after the date in the slicer table.
I'm hoping to extend this table so there might be cold drink, cakes trials etc in future. I'm wondering if PP is clever enough to make this even slicker. For the Bread trial they only want to see the result for specific products e.g. sandwiches/baguettes/wraps but also the change in the category group above which is "cold Food"
to do this currently I just set up a normal slicer and chose the products I need. i then need another pivot where i choose the group total. So the question is could I set up in my disconnect slicer somehow the list of products associated with that trial so that the products are picked automatically when the trial is selected? maybe I need to set up an additional table for each trial listing the products and some how include it as a filter on my calculation?
As an example my calculation look like this, where Trial slicer Date comes from the disconnected slicer.
So I am imagining an additional clause in the filter function that says something like && transactions[Sales Group] is in a table pointed at by the disconnected slicer choice.
Thanks for any advice as sure this is possible, but no idea of syntax
Mike
Bread trail 7/9/15
This works great as i select the trial name and then can feed the date into various formulae to calculate the transactions 4 weeks before and after the date in the slicer table.
I'm hoping to extend this table so there might be cold drink, cakes trials etc in future. I'm wondering if PP is clever enough to make this even slicker. For the Bread trial they only want to see the result for specific products e.g. sandwiches/baguettes/wraps but also the change in the category group above which is "cold Food"
to do this currently I just set up a normal slicer and chose the products I need. i then need another pivot where i choose the group total. So the question is could I set up in my disconnect slicer somehow the list of products associated with that trial so that the products are picked automatically when the trial is selected? maybe I need to set up an additional table for each trial listing the products and some how include it as a filter on my calculation?
As an example my calculation look like this, where Trial slicer Date comes from the disconnected slicer.
Code:
CALCULATE( [Av Daily Item Count Paid],
FILTER(
RELATEDTABLE(Transactions),
Transactions[Transaction Date]>=[Trial Date Slicer]-28 &&
Transactions[Transaction Date]<[Trial Date Slicer]
)
)So I am imagining an additional clause in the filter function that says something like && transactions[Sales Group] is in a table pointed at by the disconnected slicer choice.
Thanks for any advice as sure this is possible, but no idea of syntax
Mike
