change position

[soniasweety]

Hi All,

Bala Bhaskar

i want to display the one dimension as last column means after the measure

i have 3 requirments  in straight table is working as expected

so i want that to be reflected same in pivot table and Adhoc report table aswell

is there any work around?

PFA. sample

Thanks

Sony

[PrashantSangle]

Yes you are right, but if there is any hidden field in table then we can not drag it to end.

that's why I have suggested him to 1st unhide all expression i.e. remove conditional show from expression and dimension tab arrange that dimension at end.

Then again apply all show conditional statement.

Regards,

[manoj217]

Yes true prashant first he need to arrange the position then only we perform the conditions

[manoj217]

please mention what is that option how to acheive that