Skip to Content
avatar image
Former Member

Cross tab hiding a column

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


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

Cross tab formula


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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers