KPI from table Total

Aasir — Fri, 15 Nov 2024 21:05:27 GMT

Hi Team,

I have the below table and the following is the expression I used for Budgeted Volume.
I want to display this Total as a KPI and should be dynamic with selections on Month.
I don't want to adjust my data model, Need a solution with expression. Thanks in Advance

If(Month = 'Jul', SUM({< [Attribute field] = {'Jul-23'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Aug', SUM({< [Attribute field] = {'Aug-23'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Sep', SUM({< [Attribute field] = {'Sep-23'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Oct', SUM({< [Attribute field] = {'Oct-23'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Nov', SUM({< [Attribute field] = {'Nov-23'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Dec', SUM({< [Attribute field] = {'Dec-23'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Jan', SUM({< [Attribute field] = {'Jan-24'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [MUFW Clinic.Data field]),
If(Month = 'Feb', SUM({< [Attribute field] = {'Feb-24'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Mar', SUM({< [Attribute field] = {'Mar-24'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Apr', SUM({< [Attribute field] = {'Apr-24'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'May', SUM({< [Attribute field] = {'May-24'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
If(Month = 'Jun', SUM({< [Attribute field] = {'Jun-24'}, [Input Type (Volume or Revenue)] = {"Volume"} >} [Data field]),
))))))))))))

Re: KPI from table Total

Nagaraju_KCS — Thu, 01 Feb 2024 03:39:17 GMT

simple expression you can write

SUM(Budget) - This returns the total budget without selection, shows the budget related month data when the user selects any month.

Re: KPI from table Total

Aasir — Thu, 01 Feb 2024 04:17:59 GMT

This is not dynamic with selections as there are no associations between

topic Re: KPI from table Total in App Development

KPI from table Total

Re: KPI from table Total

Re: KPI from table Total