Skip to Content
0
Nov 13, 2018 at 09:22 PM

Crosstab column

119 Views

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

Attachments

14pusdays.jpg (45.0 kB)