Hello
Ok, so it's fairly straightforward to use the Slicer to pick up the information from a row of data it's related to but is is possible to use either PowerPivot or Excel to and display the results from the subsequent four rows?
I have a relatively simple data set where each row represents a week, each week has a number of data columns. Occassionally, however, we have treatments and I set up Excel with a column where the treatment is recorded as 1 - i.e. a treatment occurred that week, otherwise the cells are left blank.
I AddColumn in PowerPivot to generate a unique identifier (through the usual ampersand formula) to represent whether a treatment occurred in a specific week. Using the Slicer, I can PivotTable to see the data from the row where the treatment took place because all this info is related to that week, but seeing the data for following four weeks would let me see whether the treatment had made an effect.
I guess my query is whether the Slicer can be modified in such a way as to report the row it's associated with plus subsequent rows...
Great forum, by the way!
Ok, so it's fairly straightforward to use the Slicer to pick up the information from a row of data it's related to but is is possible to use either PowerPivot or Excel to and display the results from the subsequent four rows?
I have a relatively simple data set where each row represents a week, each week has a number of data columns. Occassionally, however, we have treatments and I set up Excel with a column where the treatment is recorded as 1 - i.e. a treatment occurred that week, otherwise the cells are left blank.
I AddColumn in PowerPivot to generate a unique identifier (through the usual ampersand formula) to represent whether a treatment occurred in a specific week. Using the Slicer, I can PivotTable to see the data from the row where the treatment took place because all this info is related to that week, but seeing the data for following four weeks would let me see whether the treatment had made an effect.
I guess my query is whether the Slicer can be modified in such a way as to report the row it's associated with plus subsequent rows...
Great forum, by the way!
