Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Aasir
Creator III
Creator III

KPI from table Total

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

Aasir_0-1706754571702.png

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]),
))))))))))))

 

 

Labels (1)
2 Replies
qv_testing
Specialist II
Specialist II

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.

Aasir
Creator III
Creator III
Author

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