Forum Discussion
Display mutliple columns under a Name (No hierarchy /No grouping)
HI Tahreem and Zhengdong Xu,
The solution is sorted without creating DAX / Table. In data Modelling for cube, below are the steps.
1. we have to select device_code (under my scenario here), Just type name "More Fields" under Display Folder and make it visible . Note: Type the text More Fields without quotes.
2. CTRL+CLICK the remaining fields which to be listed below, and give the name as More Fields\SubDevice and make the remaining fields as Visible here too. Note: After \, the name can be any.For my scenario, i have kept the name as SubDevice.
3. On Saving, we will see multiple sub folders in desktop, once published, all the fields will show under 1 name "More Fields". Here it go!!! Thank You Both for considering the post and have given your valuable inputs too.
Super UserAnonymous That is not doable to bring a new table under any exisiting tables.
Quick question, What's the purpose of bringing this new table under exiting table?
HI Tahreem,
Thank you for replying back. i need this under MAIN table for cube purpose, where the user wants to see the value against hierarchy level or with individual column level. There are dimensions where the individual columns crossing 10, which will be lengthy on seeing in cube mode.. I just need a common name to club individual fields together under every dimension.