Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
We are generating the Straight table with the help of macro. In that one of the field we wants to sort it by "Load Order: Original". For example if the "Dimension=Month" then sort it by "Load Order: Original". How can I achieve this with the help of macro.
Following is the sample of code which we were using in the macro for setting up the number properties. I want to similar kind of coding to add to sort the Dimension: "Month" by "Load Order: Original".
SET objNumberProperties = objPivotTableProperties.Expressions.Item(intAddedMeasureCount + intLoop).Item(0).Data.ExpressionVisual.NumberPresentation
objNumberProperties.Fmt = "#,##0.000"
objNumberProperties.nDec = 0
objNumberProperties.Thou = ","
objNumberProperties.Type = 11
Hope some one can help me out on this soon as it is little urgent.
Thanks
Attitude
Hi Deepak,
Macro is working fine to add a straight table in the active document - active sheet. But is there any way we can add expression and dimension in the macro .