Forum Discussion
SpaneshS
5 years agoFrequent Visitor
Benchmarking month as variable
Hi all, I've requirement to compare Current month sales with Last month sales ,Last year same month sales and Benchmarking month sales. But Benchmarking month need to keep it as var...
Anonymous
5 years agoNot applicable
Hi SpaneshS
So what are your dynamic rules? If there are no rules, you can only set the slicer separately to filter the data of different tables and then compare them.
Best Regards
Community Support Team _ Ailsa Tao
SpaneshS
5 years agoFrequent Visitor
Hi Anonymous
My dynamic rules are the values should be cumulative,BM should be either selective or we can make it as Top sales in that particular Financial year (march - april)