How to exclude no data columns in Pivot table

[vpawan]

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

[MFelix · Accepted solution]

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:

[HotChilli]

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.