Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Have ש pivot table with three dimensions and one expression,
the table is fully expanded and the third dimension shows only top 10.
I want that the third dimension will be in descending order by the expression.
any idea.
Thanks,
Jacob
or even better, your qvf
I just created one with the data you posted
And the qvf..
Please give it a go and let me know,
Cheers,
Luis
I think that I wasn't clear, my desire is that in each store + Group the items will be sorted by the quantity.
i.e
Shop | Group | sum(Qty) |
A | I | 58 |
54 | ||
35 | ||
B | I | 85 |
42 | ||
23 | ||
II | 55 | |
22 | ||
15 |
Hi, those items in the screenshot are sorted by the quantity for each shop and group.
I still don't get it
Where are the items?
like this?
Hi Jacob,
Please let me know if you still have this question
Cheers,
Luis
PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others
Hi,
The solution you offered is working depending on the data set, in my case is not working well...
Hi Jacob,
When you created the post offered a requirement and some data, then I provided you with a solution that proved to solve the problem as you posted it.
I don't have any information about your data set, I only have the information you provided. If you want, please create another post with information that's closer to your situation.
As for this post, can you please close it?
Many thanks,
Luis
Awesome Luis! luismadriz
I was searching all day for this solution and finally found it in the qvf file you've shared over here.
This saves me a weekend shift, so cheers to you mate
Your efforts are much appreciated!
Mike