Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I noticed a strange behavior: in my pivot chart I use the dropdown select option. That works smoothly for all dimensions ... except for the very last dimension.
When hitting the dropdown arrow of "dim2" I get the following result:
As soon as I add an expression (or even some subsequent dimensions) it works:
In my specific cas I would like to use a pivot table without any expressions and it's a pity that the last dimension isn't searchable ... is that a bug?!
Please find the attached qvw.
Thanks,
Florian
Can't you use a Straight Table for this? It would be the same and it works.
Thanks, but pivoting is necessary in that case. As a workaround I will simply add a narrow empty calculated dimension at the end ... not beautiful, but at least it works.
How can I report that as a bug?
Regards,
Florian
It isn't a bug - it worked as designed. A pivot need a expression. But you could set the width from these expression on 0:
sub x
set chart = ActiveDocument.GetSheetObject("CH02")
chart.SetPixWidth 0,100
chart.SetPixWidth 1,100
chart.SetPixWidth 2, 0
end sub
- Marcus
I don't really understand why a pivot shouldn't work without an expression (a straight table does)
Thanks for your macro tipp ...
Regards,
Florian