Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
hi,
Use your expression for summarization as below
sum({<FieldName ={'Happy','Young','Large'}>} Amount)
I hope this helps.
Deepak
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.
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.
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
hi,
Please find the attachment. I hope this helps.
Deepak Kurup
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
Hi RoiUser,
Thank you for the info. Cross table is what I need to use.