Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I am using this expression to calculate TOTAL's But even though YEar is Selected in Dimension , The expression is showing TOTAL across all Years
sum(TOTAL{<Metric={'VHL'}>}Data)/1000)
Can you help me incorporating Year Dimension in the above formula
Thanks,
Sai
Try like;
sum(TOTAL{<Metric={'VHL'},year={"$(=max(year))"}>}Data)/1000)
So it might work when your selecting the year that will be the max year.
Regards,
Ajay
Hi
It sounds like the Year field is not associated with the Metric and Data fields.In other words, there is no key between the table containing Year and the tables(s) containing the other fields. Check your table structure in the viewer (File | Table Viewer)
HTH
Jonathan
TRY LIKE BELOW
sum(TOTAL <YEar > {<Metric={'VHL'}>}Data)/1000
Thanks for the response ,
But none of them is working , actually my year is coming from a Dimension Month Name
I am using a Left Function ; LEFT([Month Name],4) etc..,
How do I fit the above with Total
@jonathan dienst - All fields are in single Table
thanks,
Sai
Hi Sai,
Can you please share your app.