Comparing Sales values in 2 random dates

[Anonymous]

Hi All,

I am seeking your help in this as i need to compare Sales between 2 different random dates selected from 2 multiboxes (drop down menu for dates) as each multibox will include all the dates available in the imported files. so there will be first multivox named as "date 1" and other multibox named as "date 2"

For example: if i want to campare sales happened in 2 random dates so i will select date 1 mulitibox as: 18 of July 2018 and  in date 2 multibox i will select 26 of march 2017 (or any random date)

Thanks in advance.

[Anonymous]

all data are in the same table, so when i chose any date from date 1 it shows the sales happened at that date, but then when i choose any date from date 2 it overides my first selection and both dates and values (sales of date 2 and sales of date 2)  will be the same, so how to separate them as if they are from 2 different tables? ( given that all sales data is in the same table).

[maxgro]

Maybe with alternate state,

an example in the attachment

[balabhaskarqlik]

May be this one helps:

Re: How can I compare records from same dataset

[Anonymous]

‌Thank you all, i tried using alternate state and it worked.

Thanks a lot for your help. Much appreciate.