Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have two tables one for the sales of 2017 and the other for the sales of 2015 with the same fields
like date, store, amount and i concatenate them. In a chart i want to compare only the stores that 2017 has with the same of 2015. In 2015 i have more stores and i don't want them in the chart. In one expression i have the data for 2017 and in the other expression i have the data from 2015.
How can i do this ?
Thank you in advance.
1) Sum({<Year = {2015}, Store = p({<Year = {2017}>}) >} Measure)
2) Sum({<Year = {2017}>} Measure)
Hello Gou,
can you write how your table construction looks exactly?
First one you have to choose Bar chart to compare year analysis. And, Then measures looks like
1) Sum({<Year = {2015}>} Measure)
2) Sum({<Year = {2017}>} Measure)
date store amount
01/03/2015 101 1.000
01/03/2015 103 4.000
01/03/2015 105 3.000
04/03/2015 105 2.000
date store amount
01/03/2017 101 1.000
01/03/2017 103 4.000
04/03/2017 105 2.000
I want to have for example for the date 01/03/2017 the stores 101 and 103 and for the period 01/03/2015 the same stores 101 and 103 not the 105
Hello Anil.
In the first expression i will have all the stores that the 2015 has and i don't want it. I want to have only the stores that the 2017 has.
1) Sum({<Year = {2015}, Store = p({<Year = {2017}>}) >} Measure)
2) Sum({<Year = {2017}>} Measure)
It is correct.
Thank you very match Stefan.