QlikView average Value with nulls

[AB]

Hi all, i'v a problem with average values in case of nulls... in the attached file there is a sample... I need to calculate the average in two ways: in the totals column, i need to use the selected months. in the monthly columns, use 1.. i hope anyone can help me!!

[Arthur_Fong]

There you go:

Use Dimensionality() and SecondDimensionality() to identify the hierarchy of the table.

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Alessandro, did Arthur's post help you get things working as you desire?  If so, be sure to use the Accept as Solution button on his post to give him credit and mark the post as a working solution.  If you did something else, consider documenting that and mark that post, and if you are still working on things, leave us an update.

Regards,
Brett