Crosstab column

[Former Member]

14pusdays.jpg

Hello everyone,

I created a crosstab in WEBI, and am getting an extra column. My column is specified by a variable that displays the number of days between order and delivery date between 2 and 14:

=[Var_DaysBtnOrder∇_Traditional] Where ([Var_DaysBtnOrder∇_Traditional] Between(2;14))

(Var_DaysBTNOrder∇_Traditional =DaysBetween([Traditional].[Order Date];[Traditional].[Delivery Dt - Out]))

It gives me 2-14 at the top, but then it gives me an extra column with all the rest of the data, I want the columns to end at 14. How can I fix this?

Thank you,

Kelly

[amitrathi239 · Accepted solution]

Right click on the row 2 to 14 values and add filter NOT EQUAL to null or empty value..

In other words add filter on variables which gives you 2 to 14 values and exclude null or empty

[Former Member]

Thank you Amit! My table looks so much better now.

[Former Member]

I tried out your solution, and it did get rid of the last column, but now the percentages are off, it should not be 100% by day 14, it should be 99.something%.

I want the percentage to be meaasured against all days, even those above 14.

percentages-are-incorrect.png

[amitrathi239]

use nofilter() function in percentage variable.

=nofilter(your calculation)