How to show the total value of a field beside a particular selected value

[#1]

Hello Everyone,

As I mentioned in the attachment,if I select an area and a garden it will show the corresponding sold qty. of the selected garden's season wise. But I want to show the total value of all the garden under the selected area beside the value of a particular garden of a season.Is it possible that I can also show all the total sold qty value of total area beside a selected garden's Sold Qty. value.

Thanks,

Raj

[deepakk]

hi,

Use the expression as below

Sum( {<Garde= {"*"}>} Qty).

I hope this helps.

[#3]

Hi,

No,this was not worked.Suppose I select an Area and then a garden then it should shown the sold qty.of that particular garden and total sold qty.value of the area beside the sold qty.value of the selected garden.

Thanks,

Raj

[johnw]

Expanding on Deepak's answer, maybe this?

sum({<Garden=>} total <Area> Qty)

If that isn't it, how about showing what you actually want to display? I'm very confused by your description.

[#5]

Hello Sir,

Let me explain it.As you seen in the first snapshot,if I select a garden it will show the corresponding sold qty.and beside that value I want to show the total avg.sold qty of all the garden under this area.Please see the snap I explain it there what I want to do.

Thanks & Regards,

Raj

[deepakk · Accepted solution]

hi,

If i understand your requirment correctly. this is want you are looking at.

First expression (Sold Qty) : Sum(Qty)... > this will provide you qty as per the selected Garden or Area.

Second expression (Avg Qty) : Sum({<Garden=>} Qty) / Sum ({<Garden=>} total Qty) .. this will give you average irrespective of the selection.

I hope this what you are looking for.