How can i compare the same stores from two different periods

[geogou1973]

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.

[Ralf_Heukäufer]

Hello Gou,

can you write how your table construction looks exactly?

[Anil_Babu_Samineni]

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)

[geogou1973]

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

[geogou1973]

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.

[swuehl · Accepted solution]

1) Sum({<Year = {2015}, Store = p({<Year = {2017}>}) >} Measure)

2) Sum({<Year = {2017}>} Measure)

[geogou1973]

It is correct.

Thank you very match Stefan.