Unable to convert straight table to Pivot table

Wed, 04 Nov 2015 06:03:23 GMT

Hi all,

I have a straight table below. 'SEP' is expression:

if(StartDate_WTH<='09/30/2015' and EndDate_WTH>='09/30/2015' and TenancyStatus_WTH='Vacant Tenantable'

and (num('09/30/2015')-StartDate_WTH+1)>=15,1,0)

There are several problems:

1. The 'Expression Total' in Expression Tab didn't work. No total number showed.

2. I'd like to calculate the total number of each property. So I wrote expression:

sum(aggr(if(StartDate_WTH<='09/30/2015' and EndDate_WTH>='09/30/2015' and TenancyStatus_WTH='Vacant Tenantable'

and (num('09/30/2015')-StartDate_WTH+1)>=15,1,0),Property_NO))

but there was no data.

3. I'd like to convert the straight table to pivot table. But there is error. No data in it.

Is there something wrong with my expression?

thanks

Re: Unable to convert straight table to Pivot table

sasikanth — Wed, 04 Nov 2015 09:56:08 GMT

HI,

Please Attach your qvw, it would be helpful

jonathandienst — Wed, 04 Nov 2015 10:02:54 GMT

The dimensions in the Aggr() must include all the table dimensions. From your screenshot, Property_NO is not the only dimension