How to calculate average customers they spend

[#1]

Hi anyone Pls help me this fix ..?

I have an Year wise customer sales amount data

I want to calculate avg amount customer spend each year..?

[#2]

Hi,

Use the average function Avg(Amount) in your expression and use the YEAR as dimension in your chart.

[techvarun]

please post the sample data then i can post the exact script.

otherwise please refer to Mr:venugopal4s's Answer

Regards