Lifetime sales along with date level sales

Question & Answer
, , ,
1

Hi Team,
I need to display fields like Lifetime Sales and Sales along with Date column .
when i want to change the date filter to some other dates only sales column data should cange based on selected date but lifetime sales data column shouldnot effect
For example as shown in below screenshot
image

2

Hi @manideep1

You can use calculated fields to separate the logic for “Sales” and “Lifetime Sales” while applying filters only to the “Sales” column.

Use a formula that ignores date filters. You can achieve this by using a Level Aware Calculation (LAC), which uses the sumOver() function. The sales column can remain unchanged and will be affected by the date filter.

Example : (Syntax may vary)

sumOver(Sales, [Player])

Please refer the below documentation this might be helpful for you.

1 Like
3

Thanks @Xclipse , it worked for me thanks
I had used sumover(aggregated_value, group value, PRE-FILTER)
sumover(sales,player,pre-filter

1 Like