Records constant in a Straight Table irrspective of selection?

[dmohanty]

Hi All,,

I have a small requirement.

Let say I have a table with fields ID (A,B,C,D,E) Date and Sales.

I should compare the the Sales of ID (B,C,D,E) for each date with same date and ID = A.

So in my Straight Table, ID filed with A values will remain constant despite of selection of other ID values from a List Box (ID should be selected from a List Box). Chart should look like this:

ID= A	Other IDs	Dates	Sales of A	Sales of B
A	B	xxxx	xxxx	xxxx
A	B	xxxx	xxxx	xxxx
A	C	xxxx	xxxx	xxxx
A	C	xxxx	xxxx	xxxx
A	D	xxxx	xxxx	xxxx
A	E	xxxx	xxxx	xxxx

Could someone please help me doing this on Chart Level, not in script level?

Regards!!

[#2]

Hi DMohanty,

This isn't an answer but the following links could prove useful.

Customizable Straight Table

Conditional Dimensions and Expressions – Tips and Tricks

Good luck with this!

[dmohanty]

Hi All,

Any suggestions on above request please?

[jsingh71]

Can your share Some Sample Data.

--Jai

[dmohanty]

Hi Jai,

This can be an example below:

ID	Dates	Sales
A	24/04/2014	100
A	25/04/2014	160
B	25/04/2014	130
C	24/04/2014	140
D	25/04/2014	180
E	24/04/2014	80
E	25/04/2014	110

[#6]

Hi,

I think it is not possible.

A suggestion from my side

Create a CyclicGroup and add the below 2 expressions in it

=IF(Match(ID,'A')>0,ID)

=IF(Match(ID,'B','C','D','E')>0,ID)

Add this group as  dimension in your chart and check on suppressnull

[#7]

Hi

please try this

attached file

Thanks

Michael

[sunilkumarqv]

you can change Dimension into calculated Dimension =if(ID='A',ID) instead of ID

or

use of  alternate state

let me know any clarification

[dmohanty]

Hi SUnil,

In this case, if I select any ID from the List Box apart from 'A', this calculated dimension becomes NULL.

Suppose if I select 'B', then the first field should show 'A' (no change) and the 2nd column should show only 'B'

Hope I am clear

[#10]

Hi

With Dates & ID as your dimension, put the following formula into the expression box (this is to have the answer in one column):

Sum({<ID = {'A'}>}Sales)

+

Sum({<ID -= {'A'}>}Sales)

If you want it in two columns (as in your example),

Expression 1:

Sum({<ID = {'A'}>}Sales)

Expression 2:

Sum({<ID -= {'A'}>}Sales)

Hope that helps!

Byron