Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can try this
Sum(Aggr(Count({1} DISTINCT Date), Date, Risk Grade old, Risk Grade New))