Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to show the sum of a value of a dimension in a KPI. I have created the following hypothetical example to illustrate.
Sales | |
North | 956.376,34 € |
South | 805.544,99 € |
East | 686.844,42 € |
West | 581.089,77 € |
* Dimension: Sales | |
* North, South, East, West are dimensional values |
North | |
John | 315.604,19 € |
Bob | 191.275,27 € |
Billy | 239.094,08 € |
Lincoln | 210.402,79 € |
* Breakdown of North |
What would be the best way to show the total sum of all sales in North, i.e., 956.376,34 € in the front end? My formula is
sum(if(Type='ComponentCVaR',Type,null())) but it is not working...
Thank you.
Since Type is a text value, you don't want to sum() this, right?
Try summing a numeric field.
What is Type here?
Hello,
If Type is a text field it will not work.
You can try one of the following expressions (adapt according to your model):
Thanks,
Estela
Assuming you have a Field called "Sales" in your data that has both text and number.
For dimension: =Capitalize(KeepChar(lower(Sales),'abcdefghijklmnopqrstuvwxyz€'))
For expression: =sum(PurgeChar(lower(Sales),'abcdefghijklmnopqrstuvwxyz€'))
Sales is your field.
Hi Allen,
Use Pivot table extension and use
Dimension: Sales, Name
Expression: Sum(Type)
And use Subtotals.
Regards,
Jagan.