thank you for your qiuck answer.
Your solution almost works. My first dimension, Datum (Date), shows a cumulated value of the balance sheet, raw materials. The second dimension, Bezeichnung, shows every single position of the cumulated value of the balance sheet. With your scripting on the second dimension, I can see top 10 single positions with the right value. But on the first dimension (Datum) I just can see 10 positions of the cumulated value of the balance sheet. I need to see all values from December 2015 to December 2016. I hope I explained my problem understandable enough.
Do you have an idea how to solve the problem?
Thanks for your help1
I hope my screenshots help to understand my issue.
The screenshot shows the values based on the first Dimension (Datum). On the Table below I just can´t see every value like in the bar chart above. I would like to see every month with the value on the chart and the table. In the table I used your scripting.
This screenshot shows one month which I chose to see the details of the month. Here you can see the second dimension (Bezeichnung). Your script works the way it should.
I really hope my problem now is unterstandable.
The first one shows every month, that works. But it doesn´t show the correct values.
Dezember should have a value of 3.515 T€, but with the expression the value rises to 4.655 T€. Another problem is if I change from 10 to 5 in the expresion the value of December decrease to 4.219 T€.
Why does the TOP N position influence the value of December?
Thanks for your help, without your help I would have a big problem!