Straight Table problem remaining value problem

[#1]

Hi friends

i have Straight Table which will have indicator .that is if the required quantity is greater than the available quantity(indicator in red).We are trying to show next 5 days.My Problem is if  the Required Qty is less than  Available qty(Indicator in green),RequiredQty-Available Qty=remaining value.That remaining value has to be added to the next Day?

How can i Achieve it?

Please help me out

Thanks in advance

[#2]

Hi friends

here i have Attached the image

[Anonymous]

Hi suresh ,

using the pivot/stright table you can do it.

I dont know you can use the indicator in thest table instead of this you can change the table row/col cell color red or

green based on your condition.

like quantity is greater than the available quantity then that cell will display in red background color.

to achieve this you can give the condition in the expression tab of chart properties.

see the image

[Anonymous]

Hi

     Image file