Forum Discussion

SBIM's avatar
SBIM
Helper I
3 years ago
Solved

How do I aggregate a column in a table

I am trying to create a column to aggregate the data below by market and fiscal month. In Excel it is quite easy using a COUNTIFS function i.e. MonthlyLeads = COUNTIFS(B:B,B2,J:J,J2) But I can't figu...
Need Help
Tutorial Requests
  • SBIM's avatar
    SBIM
    3 years ago

    I managed to figure it out. I needed to add a column that combines both criteria and then calculates it using a COUNTA and all ALLEXCEPT

    MarketMonth = ils_IssuedLeads[Market] & " - " & ils_IssuedLeads[FiscalMonthKey]
    2 test = CALCULATE ( COUNTA ( ils_IssuedLeads[MarketMonth] ), ALLEXCEPT(ils_IssuedLeads, ils_IssuedLeads[MarketMonth] ) )

     

SBIM's avatar
SBIM
Helper I
3 years ago

I managed to figure it out. I needed to add a column that combines both criteria and then calculates it using a COUNTA and all ALLEXCEPT

MarketMonth = ils_IssuedLeads[Market] & " - " & ils_IssuedLeads[FiscalMonthKey]
2 test = CALCULATE ( COUNTA ( ils_IssuedLeads[MarketMonth] ), ALLEXCEPT(ils_IssuedLeads, ils_IssuedLeads[MarketMonth] ) )