Calculate and Color cells in Pivot Chart base on data from previous rows

PY — Sat, 16 Nov 2024 04:57:43 GMT

Anyone know if it is possible to calculate and color cells using data from previous cells in a pivot table?

The requirement is to highlight in different colors whether Available Stock can fulfill Demand from Customers.

In the Pivot Chart above, for Parts <Charlie>, the Cell for Customer <A> should be colored Green for fully fulfilled, the Cell for Customer <B> should be Yellow for partially fulfilled (need 5 but only have 2 after fulfilling customer <A>) and finally the Cell for Customer <C> should be Red for not able to fulfilled.

Re: Calculate and Color cells in Pivot Chart base on data from previous rows

Gysbert_Wassenaar — Fri, 14 Dec 2018 07:25:33 GMT

See attached qvw

Re: Calculate and Color cells in Pivot Chart base on data from previous rows

PY — Fri, 14 Dec 2018 07:33:25 GMT

Thank you so much for the solution.

topic Re: Calculate and Color cells in Pivot Chart base on data from previous rows in QlikView

Calculate and Color cells in Pivot Chart base on data from previous rows

Re: Calculate and Color cells in Pivot Chart base on data from previous rows

Re: Calculate and Color cells in Pivot Chart base on data from previous rows