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?
Thanks @Fowmy GP$ is going to be a simple measure: revenue - cost. Revenue is a column. It's a visual. Also, I'm trying to make this solution work at any granularity. For instance, if, say, I have multiple aggregation levels, like, product segment that has many items. What will the result be if i were to drill up to the product segment? And, say, now there is even one more level, say, salesperson that has many segments, what will the result at that level? Thanks!