Pivot table ,Unable to caluclate avg in pivot table

[#1]

Dear all,

I have posted sample data i need pivot table as shown in the image posted here,

Thanks in advance

Vinod

[lvf]

Hi Vinod

Hope this is still useful - Find attached.

I just build the Average and Total values as expressions.

[#3]

Try this:

=avg( aggr(sum({$<Exports={'Exp2', 'Exp1'}>}Value),Exports,Week ))

Best,

Matt

[#4]

Hi Vinod,

Both of the above solutions work. If you're using either can you mark one as correct and close the post?

Thanks!

Matt