Filtering concepts

[Kiran_Gundu]

HI,

I have data as

Project  cost           revenue

p1          1000              2000

P2           2000             4000

P3           3000              6000

p4           4000            10000

p5          5000              12000

Now i am trying to generate report like 

Project Cost       Revenue     Profit = rev - cost           Profit percentage= Profit/revenue

if i filter Project the report shows 

Project1  Total cost,total revenue, total profit, profit percentages

if i not filter it shows everything total

thanks

[v-jiascu-msft]

Hi @Kiran_Gundu,

Did it help? Can you mark it as an answer?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Kiran_Gundu,

Please check out the demo in the attachment.

1. Add two columns.

Profit = [revenue] - [cost] 

Profit Percentage = [Profit] / [revenue]

2. Create a table visual and a slicer.

Best Regards,

Dale