Creating Monthly Average based on the Item Names

[#1]

I have a monthly average variable and I am wanting to put that into my straight table chart.

The field shows up when I put it in the expression with the correct monthly average for a total of all my item names BUT I want the monthly average to calculate based on the individual names and not adding all the items to get the total monthly average.

[MarcoWedel]

please post sample data and required result to clarify your request.

thanks

regards

Marco

[danieloberbilli]

I guess the expression in your variable contains a '='   like   vVariable = '=Avg(Field)'  try tpo remove the '='   -> vVariable ='Avg(Field)'

[#4]

Below is what it looks like now when I select the InventoryCD. for the monthly average.

What I want it to look like is...As you can see here when I select one InventoryCD I get the Monthly Average of 126. What I am wanting in the image above is to see that 126 instead of the 2271000 on the line for the item 1070SP.

Below is what my Monthly Average variable looks like currently.

[#5]

Below is what it looks like now when I select the InventoryCD. for the monthly average.

What I want it to look like is...As you can see here when I select one InventoryCD I get the Monthly Average of 126. What I am wanting in the image above is to see that 126 instead of the 2271000 on the line for the item 1070SP.

Below is what my Monthly Average variable looks like currently.

[#6]

When I remove the = sign this ends up showing no data.