Forum Discussion
AdministratorHow do I add specific calculations in an Aggregate Row Accounts catalog
I have a Catalog of Accounts in the Rows and in Columns the Amount of Each Account in a Matrix
Amount
Account A 2000
Account B 5000
NV 2.5
Account C 500
NV2 4.0
NV= New Record to add but that will be the Division between Account B/Account A
NV2= New Record to add but that will be the Division between Account A / Account C
The accounts come from a DimCuentas and with DAX the NV values were added. NV2, etc, so in the table of accounts there are already those new rows, but I have to make calculations between those values, how can I do it?
3 Replies
Syndicate_AdminThis is the detail of what you want to do
Calculation between lines of Accounts
What is in Blue are the direct values of the Catalog of Accounts with their Amount, and the records were added in gray, but the value is the calculation between the amounts of the accounts
- v-angzheng-msft
Community Support
Hi, Syndicate_Admin
The blue ones are the values that already exist, and the gray ones are the values you want to add, is that right?
There is no direct way to add a record to a custom row.
You could append data to the bottom from the original data.
Or you create measures and display the measures in the matrixBest Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- Syndicate_Admin
Hello good day, so it is what is in blue is what I already bring as Metrica, for each account of my DimCuentas, and what is in gray (sales by CU, %Gross Sale) are the calculations (additional rows) that I am creating in my dimCuentas table, and I need to make the calculation between the blue values and show them in the gray row
I can't add it in columns
Hopefully there is some solution
Thank you very much for the support
