trying to replicate chart in tablebox

[#1]

I have a chart which displays data based on the these conditions..

count(DISTINCT{ $<[EVENT_GROUP] = {HIRE}>} EMPLID)
+
count(DISTINCT{ $<[BUS_PROCESS_TYPE] ={"HIRE"}>} EMPLOYEE_ID)

how can I replace the same in table box or pivot..

Year and Month are my dims..

I was trying to write if in pivot or in table box but it is not quite simple..any help would be appreciated.

[settu_periasamy]

[jagan]

Hi Venkat,

There is no concept of expression in Table box, so it is not possible in Tablebox, so you can try using Pivot/Straight tables.  Add whatever dimensions you want in Straight /Pivot table and give this expression.  This will works.

Regards,

Jagan.

[Anonymous]

Hi Venkat,

It won't work for Table Box. You try replicate with pivot table and add your expression.

Hope it helps!!

[#5]

thanks everyone...I ran it thru with pivot table..:)

[petter]

Make a copy of your chart and then switch the copy over to a Straight Table or Pivot Table in the General Tab of the chart properties by clicking the icon for Straight or Pivot. You don't need to replicate all the expressions since you can copy the entire chart and switch it to the right type...

[Anonymous]

Please close this thread by marking helpful and correct.

Thank You

[jagan]

Hi Venkat,

Please close this thread by giving correct answer to the post which helps you in finding the answer.

Regards,

Jagan.

[Anonymous]

Hi Venkat,

Please mark helpful and correct for appropriate and correct answers.

Thank You

[#10]

Updated