In pie chart , how to do a calculated dimention ?

[#1]

Dear sirs , in pie chart , how to do a calculated dimention from a certain field to pick several field value , and ,  how is the relative expressions. For example , I have 2 fields , category & amt. I want to show ca1 , ca2 for dimention , and , sum relative amt in expressions. Please help.

[its_anandrjs · Accepted solution]

Hi,

Assume this example with two fields

LOAD * Inline [

category , amt

ca1,10

ca2,20

ca3,30

ca4,24 ];

1. First way is

Dim:- =if(Match(category,'ca1','ca2'),category)

Expre:- sum(amt)

2. Second Way is

Dim:-  category//Without calculated dim

Expre:- sum({<category={'ca1','ca2'}>}amt) //With SET analysis expression

Regards

Anand

[#3]

Dear Anand , Thanks. I will try it.