Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with customer name, total sales, total expenses. However, I want to add forth column in my worksheet as Profit/Loss by calculating (Total Sales - Total Expenses) for each row. Can someone help me how to do so ?
As is
Name | Total Sale | Total Expense |
---|---|---|
Ram | 50000 | 40000 |
Pramod | 40000 | 20000 |
Vijay | 3000 | 5000 |
To be
Name | Total Sale | Total Expense | Profit |
---|---|---|---|
Ram | 50000 | 40000 | 10000 |
Pramod | 40000 | 20000 | 20000 |
Vijay | 3000 | 5000 | -2000 |
**** Please provide me the solution, if I can add calculated measure or not.
HI,
The link that described the creation of calculated dimension is:
Did you try adding this new column profit with expression like below
and what are your expr used for Total Sales and TotalExpenses can you share them?
= YourTotalSalesExpr - TotalExprenseExpr
Tried originally this way only, thinking it as a simple =A-B expression by creating a dimension. However this didn't work. Getting neither results nor error.
can I know your expr used for total sales and total expenses?
Thread seems straight forward. What problem and how you are calculating for both?