Forum Discussion
How to exclude no data columns in Pivot table
Hi Team,
Can you please help me on below issue. I have created a pivot table with month column using sum of amount credit as metric.
with this metric i am not getting blank month columns like april to December.
But when i have included format function in the metric i am getting blank columns as well. Please help me to exclude blank column by using format function in the metric.
Thanks in advance
Hi vpawan ,
Since you are doing a format you are transforming the measure into a text field. Why don't you just create a measure with the sum and then format it with the syntax you have on the formatting pane:
On the highligthed area you can write the format that you are using on the measure instead of using the FORMAT syntax:
2 Replies
Remove the FORMAT - that turns the measure into a string.
There is a Formatting section for measures in Model View (just select the measure in Data section and scroll down the Properties list - there is a custom option available)
The measure will remain numeric but you can define the display format.
Hi vpawan ,
Since you are doing a format you are transforming the measure into a text field. Why don't you just create a measure with the sum and then format it with the syntax you have on the formatting pane:
On the highligthed area you can write the format that you are using on the measure instead of using the FORMAT syntax:
