I'm not at all familiar with the new BI part of Excel, but it seems to me that you need a Units Taken Row and a Six Month Liability Row.
In the attached, Play with the numbers in the yellow and watch the green.
I'm not at all familiar with the new BI part of Excel, but it seems to me that you need a Units Taken Row and a Six Month Liability Row.
In the attached, Play with the numbers in the yellow and watch the green.
Please take the time to read the Forum FAQ