Unable to convert straight table to Pivot table

[#1]

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

[sasikanth]

HI,

Please Attach your qvw, it would be helpful

[jonathandienst]

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