Graph only 3 descriptions from a list of 6 description

[Anonymous]

I have a table with several columns. They are as follow:

     Description

     Q1_2009

     Q1_2010

     Q2_2009

     Q2_2010

The Description column has 6 descriptions. They are as follow:

     Happy

     Sad

     Young

     Old

     Large

     Small

I just want to graph Happy, Young and Large and all of their data in Q1_2009, Q1_2010, Q2_2009 and Q2_2010

How can I do this?

Thanks. 

[deepakk]

hi,

Use your expression for summarization as below

sum({<FieldName ={'Happy','Young','Large'}>} Amount)

I hope this helps.

Deepak

[Anonymous]

Thanks for the info. How would I do this if I have multiple amounts? My amount is Q1_2009, Q1_2010, Q2_2009 and Q2_2010. Thanks.

[deepakk]

hi,

I hav attach a sample application. In the application, there are different categories name but i am using only bikes and clothing information for all quarters.

If you have multiple expression you can copy the set analysis code to all expressions.

[Anonymous]

Hello,

Thanks for the info. It is very helpful. However, I have several data points and I am trying to create a trend graph.

I like the graph to have bike sales for Q1_2009, Q1_2010, Q1_2011.

How can I graph this? Thanks

[deepakk]

hi,

Please find the attachment. I hope this helps.

Deepak Kurup

[lironbaram · Accepted solution]

hei

attach is another example.

some points:

1. i think it is better aprroch to do cross table on the data in the load script,

     see the script in the example

2. i think as an approch you should teach the users to select the items that they want and not use set analsys

i attched example two graph u think you should use the regulr

hope its helps you

[Anonymous]

Hi RoiUser,

Thank you for the info. Cross table is what I need to use.