set analysis

[#1]

Hi,

Please find attached the qvf file.

i want to calculate the total sum with max(fmonthCD) and metrickeyid(1).

thanks

sunindia‌@

[Anonymous]

mey be this?

=sum({<MetricKeyID={'1'}, fmonthCD={'$(=max(fmonthCD)'}>} Sales)

[deepakqlikview_123]

Try

=sum({<MetricKeyID={'1'}, fmonthCD={'$(=max(fmonthCD)'}>} Sales)

[reddy-s]

Hi Prashanth,

Try this:

=sum({<MetricKeyID={'1'}, fmonthCD={'=$(=max(fmonthCD)'}>} Sales)