Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can someone help me with the set expression for below .
Attached a sample data S/S . My goal here is to calculate Count([TradeCount]) , where I need to exclude data where ever Revenue=0, even if Trade Count or volume is not Zero. I am trying to achieve this in Pivot Chart.
Try
Count({<Sales Group-={"=Sum(Revenue)=0"}>} [TradeCount])
PS Are you sure you mean Count(TradeCount) and not Sum(TradeCount)?