How to display report based on 2 fields

[Renu9]

Hi All,

I have created a bar report where I am grouping by the field 'Supply' , I also have another field 'quantity' for each record . I have to display quantity on the data label for the particular supply and not the tickets count.

Please find below screenshot where it is displaying supply with ticket count on data label

Here 3 and 1 are the number of tickets that are with advert panels and halos, but I want the for the quantity '5' , advert panels are shown.

How is that possible?

[palanikumar]

Hi,

In Aggregation set "Sum" instead of "Count" and set the field to quantity. This will sum the quantity field and display the value.

[Renu9]

Hi @palanikumar  Quantity field is not appearing in the aggregation field

[palanikumar]

Is it a numeric field? You get this option available only with with numeric field

[Renu9]

Hi @palanikumar  It is a string field. Numeric field is not there in table dictionary.