dynamic pivot table always last dimension needed

[#1]

Hi,

I came across a problem. I have a pivot table that is being built dynamicly. So I never know what dimesion my chart will have in my expression I'm using the aggr() function so how can I built the aggr() function with all the dimensions?? is there any way?

so sometimes my chart has the dimensions store, ProductID or Store, Model, ProductID or Saison, ProductName and so on I can have up to 12 dimensions. It would be cool if anyone has and idea how to solve this problem or if anyone lets me know that this problem can't be solved

regards,

MT

[lironbaram · Accepted solution]

hi attach is an example

you have a table that it build dinamicly by selecting dimensions

look at the third expresssion in the aggr argument i use a variable who holds the selected Dimensions

that way it is doing the aggr dynamicly on the selected dimensions

hope it helps you

[#3]

Hey thank you it helps alot I just have to try it out now and now I know how I can create a dynamic chart without a macro!!! Was this already possible like that in qv10?

regards,

MT

[lironbaram]

no in qv10

the only way to do it is with macros

[#5]

ok we just changed to qv11 so i will start changing it to the way you did it it seems to be a lot faster can I do it the same way for expressions?

regards

[lironbaram]

yes yo can look at the expressions in the table

in the expresssion tab properties

you can check the conditional check box

the use the expression list in the screen

[#7]

thanks again for the example it helped me alot with a couple of things 🙂

regards,

MT