Report rejects filtering on selected Slice

Feets
New Member

Iโ€™ve tried filtering a report using the Condition Expression Builder. The objective is to look at last monthโ€™s appointments. However the expression builder will not show the right data slice. Even with the right slice selected in Table name, the columns it presents for picking in Expression Builder belong to another table.
Even if I attempt a dereference it tells me thereโ€™s no such column as โ€˜Appt Dateโ€™. Also attempted to add a File Name Prefix such as concatenate(โ€œAppt for theโ€," ",MONTH([Appt Date])-1) which also returns that itโ€™s unable to find the Column. If I try just a simple insert of the column name this also fails with same error. However Expression builder parses it happily.

0 4 150
4 REPLIES 4

Steve
Platinum 4
Platinum 4

Please post a screenshot demonstrating this.

Feets
New Member

Reordered as you wouldnt see it natively. Left is the Report Windo showing selected slice. Right is the resultant Expression Query Builder that shows columns from Client List table. Bottom what it should show.

That image makes no sense to me.

Feets
New Member

@Steve can I reach you by mail? As Iโ€™m new, the forum wont permit me now to add any more images to this post!

Top Labels in this Space