Group by Function to get the right values for the Metric

[#1]

I am trying to get the correct values for the Metrics which are influenced by two metrics, The Issue is I want to display the value in a straight table with one dimension, but the metric should include the granularity with both the dimensions one which is present and the hidden. Like In other BI tools (BO) it is done through functions like 'For each' and 'For All', Is there any specific function that I can use to get the desired result.

[jagan]

Hi,

Try using the Aggr()

Ex: Sum(Aggr(Sum(Sales), Dimension1, Dimension2))

Regards,

jagan.

[#3]

You can add both metrics as a dimension of the straight table.

Within the presentation tab you're able to hide the dimension (Hide Column)

[#4]

Thanks Erik, I am already doing this workaround, but curious to know if we can do this through functions. I tried Aggr(), it also is not giving me the required result.

[#5]

Hi Jagan - Tried using the Aggr() Function followed By the first and second Dimensions..

=Sum(Aggr(Sum(MetricStatus), MetricName, InitiativeName)),, still this is not giving me the required result. also tried all the permutations with the same formula, still no desired result. Any other thoughts.