How to show distinct sales value!

[#1]

Hi All,

I want to show the distinct sales value of item under each invoice.

For example:

Let, 0001 is the invoice number and 1000 and 1001 are the items under the invoice. I want to show the distinct sales figure of each item under the invoice. Please let me know how to do that! Currently it is showing the sales value of both the items together. I want to show the distinct sales value.

Please let me know how to do that!

[Miguel_Angel_Baeyens]

Hello Rikhab,

If I understood your question, you may add Item number field as dimension. When you expand the chart to show each item number of the invoice the expression will show that value.

Is that what you are looking for?