Get information from weekly view when in quarterly view

[Former Member]

Hi Experts,

We are using data view that displays the data in Quarters.

In the same planning book we have a weekly view.

Our issue is now that I need to calculate on an aux-keyfig. in the quarter view using data from a specifik KF in the weekly view. The issue is that I ONLY want the data from week 1, present year...

Normally you would get the aggregated data, but I need only the data from week one.

How can this be done in the quarterly view?

Looking forward to hearing from you!

Br Brian

[Former Member · Accepted solution]

Hi Brian,

If you are using a macro to this, then please try the user defined - period in the macro rather than future or past. here you can specify your own dates and it might solve your issue.

Thanks,

Chan