Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    Not fully sure if you understood me correctly. Please see the below screenshot of what I meant:

     

    Is this what you are looking for?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I dont htink i was very clear, i need the sum of the Active column :

 

This should sum to a total of 3, is there anyway i can replicat this?

AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

yes.. create a new measure as I mentioned above and use that instead of Active..