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...
Hi Anonymous ,
Has your problem been solved?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, v-lionel-msft . Sorry, I noted below that I am on vacation. I can't actually verify right now because I do not have the work laptop. I promise to verify and let you know by the end of the weekend. Thank you so much for your caring.
Hi, v-lionel-msft . Thanks so much. Your solution works. However, it works at one level only. I needed it to work for each level in the hierarchy as in the below table. Thanks so much for your efforts!