Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..
I want to show below expression in line chart...
sum({<Val_Date={">=$(vValStart)<=$(vValEnd)"}>}if(vCalCurrentDate< Val_Date,[Net Tractor Revenue (Domestic)]))
/
sum( {<Link_Date={">=$(vCalMinDate)<=$(vCalCurrentDate)"}>} [Net Tractor Revenue (Domestic)])
Please help me with this issue.
Regards,
Kavita
Have you given it a shot at your end? I don't understand your data, I will need you to give me a kick start here....
Yess...
I have tried the below expression for the denominator part..
Sum(Aggr(If(Link_Date >= max([Quarter Start]) and Link_Date <= Max([Quarter End]), Sum([Net Tractor Revenue (Domestic)])), Link_Date, [Fiscal Month]))
But its summing up the data...
Regards,
Kavita
Do you know what are the numbers you will be seeing?
Below are the values:
For QTD: if i select Jun then it should show Apr, May and June..in Trend
For YTD: If i select Jul then it should show Apr to Jul
Apr | 567.3 |
May | 639.3 |
Jun | 842.2 |
Jul | 476.7 |
Aug | 366.3 |
Sep | 883.4 |
Oct | 1,321.1 |
Nov | 462.6 |
Dec | 209.5 |
Regards,
Kavita
Wait, these are just denominator numbers? What exactly are you looking to show now? percentage or just the denominator? You have had me completely confused now
We already had this, what do you want from this now? You need two expressions, one for QTD and one for YTD?
MoM trend was successfully done..
Same i Want for Qtd and YTD...
So for testing i was using oly denominator...for Qtd and YTD..
I want that MoM trend values in QTD and YTD..