Pivot Chart

[bharatkishore]

Dear All,

I have a  issue related to pivot chart..Hope i will get the help..

I have two dimensions one is name and other one is task_type...In both the dimensions i have some 10 fields and i  required only 3 fields from name and only 4 fields from task_type..I have hardcoded..

Now the issue is i don't want to c the second dimension visible in the chart i.e. task_type..i required only fields..And i want tasktype fields in order:

1)Change request

2)Incident

3)U_request

4)Problem

Attached image for your reference..

Regards,

Bharat

[sunilkumarqv]

Hi Bharat

you want task_type in order then create a calculated dimension

If(task_type='Change request',Dual('Change request',1),

If(task_type='Incident',Dual('Incident',2),

If(task_type='U_request',Dual('U_request',3),

If(task_type='Problem',Dual('Problem',4)))))

sort in ascending order

on Dimensions table click task_type and in label give a space without any a name

[CELAMBARASAN]

For the task type dimension --> use Label as Space or =''  This will hide showing the label

And resize the column width to smaller one

[sasikanth]

HI,

Try to give empty label to the task type ,

and sort the fileds before that

[bharatkishore]

Hi Sunil..

Thanks for your reply..As per ur code i am getting other than 4 field values. So i don't want those fields and i want only 4 fields..Can u please help me on this

[sunilkumarqv]

As you create calculated dimension it restrict only four fields .

share sample data ..

[ankitaag]

Hi,

PFA the attached application.

Hope this helps!