https://bugs.documentfoundation.org/show_bug.cgi?id=172227
--- Comment #5 from Robert Lacroix <[email protected]> --- (In reply to BogdanB from comment #4) > But, Robert, if for example, row with WTE has 0 in the Total Result is one > thing, but in the Expired we have values (-9 in this case), so, how to > inform Pivot Table that we want Assignment/Bought/Expired/Sold data, but in > the same data we don't care that we have date if the Result is 0? Seems > strange what we really want. Strange indeed. The Pivot Table is not used for data analyis. It is a dashboard. We don't want to see what caused a Total Result to become zero, we already know it from the stream of data continuously appended to the bottom of the source data range. This sheet doesn't make sense because it is slimmed down for illustrating this enhancement request. The commercially sensitive columns have been stripped out. The usual key column in the left of the PT would be options contract names. So "WTE CALL 2026-07-17 36" would be a call option contract expiring July 17 for Westshore Terminals shares with a $36 strike price. None of the entries in the PT whose expiry date is in the past would be visible if we could filter out rows with Total Result = 0. The PT would be nice and small and show us only the positions which are currently open. We care only about open positions because these are the ones which give us risk exposure. A contract price might be $0.50 but is for a board lot of 100 shares, and with a $36 strike price it means $3,600 is at risk for a contract trading for $50 -- You are receiving this mail because: You are the assignee for the bug.
