Display MainGroup(1st-2digits) + LastGroup(last 4 digits) grouping in Pivot Table

[jim_chan]

HI guys,

i have to create a pivot table to show the below information in each of the pivot table column.

column 1) List out  same mainNo and SubNo record ID and category area

column 2) List out  the mainNo + SubNo for thhis record_id

column 3) List out  record ID and category_area which have diffrent MainNO+SubNo

I have attached sample. qvw file with inline data.

[MK_QSL]

Can you provide your output as well ?

[jim_chan]

[sunny_talwar]

This?

[jim_chan]

i waited you quite long bro.

not sure you can help me solve another issue or not..  can you ?

[sunny_talwar]

What issue? This one or another one?

[jim_chan]

haha. nope. this post:.

Re: bar chart with 2 dimensions 1 expression

[jim_chan]

Sunny,

I will have a look on this in a short while.

Rgds,

Jim

[jim_chan]

wow..... thats correct! and you did it in the front end!

[sunny_talwar]

Hahahaha yes I did