Nested Aggregation based on the first dimension as well as current selection

[Sibani]

Hi There,

This is a scenario where I want to aggregate the  'Risk Grade old' and 'Risk Grade New' columns based on the Rating date filter and for the multiple ratings it would not create multiple rows.

This should ultimately roll-up at the customer name level and appear in the single row.

In the above senario 5-G, 8D and 8G are 3 different rating i want this value to be driven by one of the filter called Rating Date. currently it's only rollup at the Customer name level wand irrspective of rating date.

[Chanty4u]

can try this

Sum(Aggr(Count({1} DISTINCT Date), Date, Risk Grade old, Risk Grade New))