BO WEBI Crosstab swap axis

[former_member222672]

Is there a one-click axis swap button for crosstab table?  Theoretically I could redefine data assignment, or re-create with columns / rows exchanged - but my end users need a one button axis swap as is available in Business Warehouse Web tool.  Please chime in

[Former Member]

Hi,

Create 2 Crosstabs

1)     Cosstab_AB

2)     Crosstab_BA

Add one Input Control (Radio Button Or Drop Down ) & Extra Table "Tab_Extra" Just for using as target .

Add manual LOV's in this Input control ( AB , BA ).

Now on basis of Selection Hide Unhide Crosstab_AB & Crosstab_BA

[former_member222672]

Thank you Nikhil for your input - many ways to skin a cat for sure - If BO WEBI does not have axis swap then I guess I'll have to buy more knives...