COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

[#1]

Hi All,

I want sparkline representation in my straight table, plz let me know if it is possible when 3 different calculated metrices(AB, B-C, AB/(B-C)) are present.

Quarter(Dimenssion)	AB	B-C	AB/(B-C)
Q8
Q7
Q6
Q5
Q4
Q3
Q2
Q1

Now i need to display my table in this format:

Metrics	Q8	Q7	Q6	Q5	Q4	Q3	Q2	Q1	Sparkline
AB
B-C
AB/(B-C)

I have attached a sample file.

Please let me know if anyone has any idea.

Regards

Sagar Gupta

[Lee_Matthews]

Sagar

Mini-charts do not like expressions that reference other expressions. Re-do your mini-chart expression using only field names and it should work.

[#3]

how many Quarter have you got? only this 8 or it should be automatic? (automatic will be more difficult)

[#4]

Hi Pari,

I only have 8 Quarters

Q1

Q2

Q3

Q4

Q5

Q6

Q7

Q8

Regards

Sagar Gupta

[#5]

as far as i'm concerned ...

there is no other option than :

- Q1, Q2,......Q8 must be expressions

and metrics should be dimensions