Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Comparing data with selected months and previous months

Hello,

 

I have a table called customer Transaction . Please find sample data as below. It has many rows with other cust id, year and month.

Cust IdYearMonthCol1Col2
12019JAN510
22019JAN220
32019JAN330
42019JAN10100
12019FEB1200
22019FEB220
62019FEB300400

 

I want to select year and month through Slicer and calculate New customers sales and no sales customers.

For Example if I select year= 2019 and Month = FEB, result should display as below after comparing previous month. I used calculated table, its working hard code value but not through slicer.

 

Please Help!!!!!!!

 

New Customers   
     
Cust IdYearMonthCol1Col2
62019FEB300400

 

Customers removed this month

Cust IdYearMonthCol1Col2
32019JAN330
42019JAN10100

 

Regards

Samar

 

 

No Replies