I’ve wrote a tabular report to show customer(as row) sales in 4 warehouses (as column).
The values are the total sales qty.
The column right now is dynamic, that if 1 warehouse has no sales at all, this column stands for this warehouse would not show on the report.
Is it possible to always show 4 columns, even if that warehouse has no sales.
Best answer by ray20
I found another way to fulfil my need. I do NOT use tabular report, I am using the visibility to control.
Since I need 4 fixed columns,
So I hard code them
But I make the line value visible only when this value is from that column warehouse
The results are like below: