LINE

[upaliwije]

Hi,

I have following Pivot table in my QV document

CLASS	YEAR	0	1	2
A	2011	10,000	20,000	5,000
A	2012	10,000	20,000	5,000
A	2013	10,000	20,000	5,000
A	2014	10,000	20,000	5,000
A	2015	10,000	20,000	5,000
B	2011	10,000	20,000	5,000
B	2012	10,000	20,000	5,000
B	2013	10,000	20,000	5,000
B	2014	10,000	20,000	5,000
B	2015	10,000	20,000	5,000
C	2011	10,000	20,000	5,000
C	2012	10,000	20,000	5,000
C	2013	10,000	20,000	5,000
C	2014	10,000	20,000	5,000
C	2015	10,000	20,000	5,000

I want to make the 2015 bold and draw a line in between two classes. Pls help me.

[HirisH_V7]

Hi,

In your pivot expression and Dimension -> Text Format ->

=if(mod(RowNo(total),5)=0,'<B>')

Hope this Helps,

Hirish

[tamilarasu · Accepted solution]

You need to add condition like below in all dimensions and expressions.

=if(Year = '2015', '<B><U>')

[Anonymous]

Properties -> Expression -> Expand the + sign of Expression -> Text Format -> write the desired condition -> Use formats like <b> etc...

Share a sample app if possible?

[upaliwije]

Thanks

Is there a any way drawing a  single line below the year 2015

[tamilarasu]

You meant single line for the whole row.? Sorry, I guess it's not possible. Instead, you can use some colors.