Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]),
))))))))))))
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.
This is not dynamic with selections as there are no associations between