This content has been marked as final. Show 2 replies
Alternative you can think of LEVEL BASED Measures - Stock Total, Qty Total, Price Total at Product Level gives total amounts irrespective of your filters. you need to change your report format style to use them.
I would suggest Summary - detail report approach. Show totals in the summary and in the detail report show your business logic.
Case when stock <> 0 or price <> 0 or Qty <> 0 then 1 else 0 end. Put filter <>1 to eliminate zero value records.