how to get max in a calculated Dimension in chart

[marjan_it]

Hi All,

I have a straight table that my dimension is like this:

=if(im_projectID=8231 or im_projectID=8194 or im_projectID=4302 or im_projectID=8230 or im_projectID=10117 or im_projectID=694 or im_projectID=10677 or im_projectID=10536 or im_projectID=10512 or im_projectID=5594 or im_projectID=11518 ,im_projectID)

and for expression I have sum (im_ProjectBudget). I want to get the max of (im_ProjectBudget) for just these im_projectID, not for all of them.

how can do it?

[tresesco · Accepted solution]

You can replace your calculated dimension with a simpler one like:

=If(Match(im_projectID, 8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518), im_projectID)

And then the expression like:

Max( TOTAL {<im_projectID={8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518}>} im_projectID)