I have a powerpivot table set up and would like to show only rows the QtyShort measure has a value. I tried
but all it does is sit there with the blue circle when I try to add it to the pivot table. Is there a better way to handle this?
As I'm unable to upload attachments, I'll try and show it. I want to only see the first line, not the last two.
ShipDate ShipName ItemNo QtySlsLnLessPkgLn QtyShort
1/1/15 Johns Sales AAA 12 12
BBB 12
CCC 12
Code:
=if(QtyShort<>0,qtySlslnLessPkgLn,QtySlsLnLesPkgLn-QtySlsLnLessPkgLn)
As I'm unable to upload attachments, I'll try and show it. I want to only see the first line, not the last two.
ShipDate ShipName ItemNo QtySlsLnLessPkgLn QtyShort
1/1/15 Johns Sales AAA 12 12
BBB 12
CCC 12
Last edited: