Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi My Friends Regards!...
I have some Expression Ex.
=num(Sum({<[Account]={"5*","6*","7*","8*","9*"}> - <[RSCE]={"UFNT*"}> - <[RSCE]={"AF*"}> - <[FUND]={"20*"}>}[Amount]),'#,##0.00') your name Net Asset Tithe
Other
=num(Sum({<[Account]={"5*","6*","7*","8*","9*"}> - <[RSCE]={"UFTF*"}> - <[RSCE]={"AF*"}> - <[FUND]={"20*"}>}[Amount]),'#,##0.00') your name Net Asset Not Tithe
For a KPI is Perfect but for a Chart don't work because show me all the accounts and i want grouping to show me Net Asset Tithe and Net Asset Not Tithe. I need you help...
Thanks in advanced.
Regards
Would you be able to share a sample where we can see the issue?
Firstly thank you for you answer!...
Of Course! This example I will do with two expressions mentioned. This is what it show me with chart pie Dimension Account, Measure first expression =num(Sum({<[Account]={"5*","6*","7*","8*","9*"}> - <[RSCE]={"UFNT*"}> - <[RSCE]={"AF*"}> - <[FUND]={"20*"}>}[Amount]),'#,##0.00') Name Label Net Asset Tithe
For the accounts it's fine, but I want this
The green first expression Net Asset Tithe and purple second expression Net Asset Not Tithe by group of expression not by accounts as expression. The second example I have to do Excel
Thanks again!