Forum Discussion

igibson's avatar
igibson
Frequent Visitor
8 years ago

Show data only for comp stores

In my report I need to look at sales data for stores that were open more than a year prior. I have been showing this manually by having a bookmark button on each page labeled "show comp stores" which...
Need Help
igibson's avatar
igibson
Frequent Visitor
8 years ago

I am trying to show data that is from a store that has been open for longer than one year. The goal is to be able to show only data from stores that have been open for one year using a slicer.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

igibson

 

First in my above sample, I have used parameter to filter the store data (since you didn't share us your sample data, I have to make a guess). And this parameter is defined as one year ago of current date (since you also didn't share us the definition of the contidion longer than one year, I have to make a guess too).

 

Thereby if my sample doesn't satisfy your requirement, please share us more information like your logic and some sample data.  

So that we can understand your requirement more clearly and make some proper tests. Otherwise, we can only make guesses.

 

Thanks,
Xi Jin.