I use CUBEVALUE formula works absolutely fine: it brings necessary measure with no issues. Revenue, Invoiced, per customer per product group and per year-month. Customer is taken from the drop down (...
v-chuncz-msft
Community Support
5 years ago
You may check Remarks section and visit https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat for dedicated support.