Format Pivot Table

[upaliwije]

Hi Friends

I have following pivot table in my QV Doc

Here I want to adjust Due Dates Column without affecting the 1st Column(Expressions) When I try to adjust with 1st Column too Adjusted. If there is a way to do it pls advise me.

[vinieme12]

Adjust the expressions affects all expressions , but adjusting the dimension should not affect the expression , can you post a sample?

I think you are holding the cursor over due_date  instead hold cursor in the whitespace against a dimension value

[upaliwije]

Thanks Vineeth,

I have tried as you said, But with no success. I attach sample . Pls check & advise me

[vinieme12 · Accepted solution]

  Not with multiple expressions, you will need to create an island table that has the below list of values

Renewable

Renewed Prior to 15-Aug-17

Renewed between 15-Aug-17  and Due Date

Renewed on Due Date

Renewed within 1 week of  Due Date

Renewed after 1 week of  Due Date

Total Renewed

Renewed %

New Premium

and then use either IF()  blocks or  Pick(Match(  to add expression for each value

see attached sample, i wasn't able to do a reload so i've used valuelist and If() blocks

[upaliwije]

Thanks Vineeth,

Pls also share with me  a sample of Island table

[vinieme12]

To create an island table, i will have to reload the app.

Please LOAd an inline table as below and post the updated app

LOAD * inline [

ExpressionsToUSE

Renewable

Renewed Prior to 15-Aug-17

Renewed between 15-Aug-17  and Due Date

Renewed on Due Date

Renewed within 1 week of  Due Date

Renewed after 1 week of  Due Date

Total Renewed

Renewed %

New Premium ];

[upaliwije]

I attach h/w updated app

[vinieme12]

see attached

[upaliwije]

Thanks a lot

[Anil_Babu_Samineni]

Or just Straight table by enabling the Horizontal from presentation tab?