cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with drill down in query - 2 key figures

Former Member
0 Kudos

Hi Everybody,

We currently have a key figure structure built in Query designer 7.0. The Key Figure structure contains two key figures presented in columns.

When we drill down on period in the columns, the key figures are split into several columns to present each periods data according to standard drilldown functionality.

Question: Can we select one key figure (or selection in the structure) that should not get affected by the drill down? In other words, only one of the keyfigures should be split according to the drill down, while the other one remains to show the aggregated value for all periods?

Regards,

Erwin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Can you try celll editor and may be your issue solve.

Regards

sivaraju

Former Member
0 Kudos

Hi Sivaraju,

I have already thought about it but I have now idea how to use is for this problem. Maybe some suggestion?

Regards

Erwin

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can try adding period to one of the key figures and setting the constant selection (right click, constant selection). Let me know if it helps.

Kind regards,

Alex