Forum Discussion
Exclude current row from calculation
Hi. I need to do the following. I have a table of, say, products sold. Each row shows the selling price. It also shows the profit (selling price minus cost.) The bottom of the table shows the total p...
Anonymous
Is this a Table Visual or a table in the model?
Are Revenue and GP$ are measures or columns?
Fowmy and Anonymous . I kind of got something working there. I'm yet to test it for multiple granularity levels. However, as you can see from the screen grab, the total at the bottom of GP_Impact% is wrong. The way I got it to work so far is by doing the calculation for avery row twice--once using the all() function and another without it and then dividing the two.