Aggregation in Pivot Table

[darrellbutler]

Hi

In the attached image I have a table that shows 29 activations, these are actually made up of activations across three dates. The business now only want to count activations made on the same day as 1.

Ideally the business want to see the top chart "Current View - Pivot" but instead of 29 it should read 3.

I can achieve this if I include the date but the business don't want to see this level of detail.

I'm trying to achieve this without adding or changing the underlying model.

Any thoughts would be gratefully received.

Kind regards

Darrell

[MK_QSL]

May be

SUM(Aggr(COUNT(Distinct Date),Field))

[mrossoit]

I'm not sure if this could be the right solution for your problem but have you tried to count Combined_Table_Date?