Columns in table

[deepakqlikview_123]

Hi All,

Please sample QVw file.

I need to show HighRisk and LowRisk Only once instaead of showing in front of each row as shown in first chart.

when i am trying to do this as a last column i am getting high risk and low risk in front of each row as shown in second chart .

Can you please suggest how to get this result as a last column in pivot or straight table.

thanks

[Clever_Anjos]

Like this?

[deepakqlikview_123]

Yeah but i want to show high risk and low risk only once instead of showing in front of each row in last column.

Thanks

[deepakqlikview_123]

Hi All,

Can you please suggest on this.

Thanks

[Clever_Anjos]

Would you mind preparing a sample using Excel or other program? I´m not sure I´m following you

[prajapatiamar38]

Hi,

Deepak Tibhe,I Don't think it is possible because the dimension you are putting first pivot table will group according to that dimension.

So if you want to show HighRisk and LowRisk only once you have to put that dimension first.

If it is possible please let me know,I also want to know this answer.

Thanks