Skip to Content
0

Cross tab hiding a column

Nov 22, 2017 at 11:32 AM

24

avatar image
Former Member

I have a question about crosstab wich displays totals for last 12 month. I only want to display last month totals and all totals for last 12 months without including totals of other 11 months. I have created formula to display only last month's data but it still adds column of other months' data as well

@lastmonth

Month({F_TASKS.TA_DATE})= Month(DateAdd ("m", -1, CurrentDate))

Cross tab formula

@lastmonthname

if {@Last month}=True then 'Last Month'

managed to get data suppressed by using this formula

GridLabelAt("@LastMonthName", CurrentColumnIndex) = '' "

as kindly suggested from my previous question by

Abhilash Kumar

but I still got empty column cells , so how do I get rid of those???

capture.png (12.3 kB)
capture1.png (10.3 kB)
capture.png (9.2 kB)
1gfjq.png (8.0 kB)
capture.png (11.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers