I have a question regarding refreshing of pivot tables based on report built with NL functions (no use of "table" function) and some excel calculations (this is based on HR and calculates i.e. current age, time spent in the company etc).
I have built few pivot tables/charts based on this data, but after refresh the data are limited to the first line only.
Do you know some easy solution to solve the problem?
The report in based on at least few data tables.