H function report - Manual sum rows showing #VALUE unless expand all hidden rows
SummaryH function report - Manual sum rows showing #VALUE unless expand all hidden rows
we are using excel 2016 and smart view version 610,
Ever since we started excel 2016, we started seeing new issues with our h function report from smart view.
Details of the connection source and most of the dimensions information were hidden in the first few rows of the report. We hide those rows so that the report looks presentable for "screenshot". In this report, we have rows that are manual sum of data such as subtotal of a group and grand total.
Before excel 2016, we just need to click "refresh all" and the report will get updated. the subtotal and grand total will also picked up accordingly based on updated data.