Pivot or Straight Table

[VishalWaghole]

Hello Community,

I want to use Tree List box like structure in my Straight or Pivot table.

Is this possible or not. Please help..

Please find attached QVW and image for the help.

- Thanks and Regards,

Vishal Waghole

[MK_QSL]

The best possible way is already shown by you...

[VishalWaghole]

Hi Manish,

Thanks for your valueable reply,

But can i mearge Model and Sub-Model Column in Pivot table like Tree List Box Structure.

- Regards,

Vishal

[MK_QSL]

yes.. the best can be get by adding a calculated dimension as below..

=Model & ' - '&[Sub-Model]

now you can remove Model and Sub-Model fields also..