Forum Discussion
Aggregating measures -
Hey All, I have a table basic data table like below; Consents ID Status Consent Date 1 Active 22/01/2019 1 Active 28/01/2019 1 Expired 28/12/2018 2 Revoked 09/01/2...
Not fully sure if you understood me correctly. Please see the below screenshot of what I meant:
Is this what you are looking for?
yes.. create a new measure as I mentioned above and use that instead of Active..
This replicates the active count measure i already have in place;
I am after a table which produces the following;
Where the totals should come to 3 on each Active New & Revoked/Expired.
thanks
Not fully sure if you understood me correctly. Please see the below screenshot of what I meant:
Is this what you are looking for?