Help with ValueList

[#1]

Hello Everyone,

I need to built a report in the format below:

Conditions:

1. On selection of a particular Year, count of orders delivered for the Year should be populated Quarter wise and Count of orders at the end of the Year should also be populated.

I have written two expressions which counts orders delivered and orders pending respectively based on Value List.

But for "Order not yet delivered", data for previous quarters are also getting populated ( which is actually the count of orders delivered)which is not required.

Please help to get the report in the correct format.

Thanks in advance,

Jemimah

[MindaugasBacius]

Could you please share with a sample of data?

[sushil353]

Hi,

Can you share sample application?

[marcus_sommer]

I don't understand why there are (yellow) subtotals Q1-Q4 within the column Delivery Date then the quarter will be displayed as a horizontal dimension.

Beside them I would try to solve the case within the script by creating a datamodel which the Order (delivered + not delivered), Regions and Quarter associate and the simply use as expression: count(Order) and not synthetic dimensions with valuelist.

- Marcus