Forum Discussion
Debit column of #s from my power query table show as blank in pivot table
My "citi" pivot table is displaying blank fields from the Debit column (which should, instead, be displaying #s), although it correctly displays #s in the credit column (which pulls data from my "cit...
As variant - if you add data to data model creating PivotTable and at least one value in the column is text, entire column in data model will be considered as texts. Sum of the will be blank.
ThanksSergeiBaklan but if that were the case then my "credit" column (in power query) which shows text "null" would also not display in the pivot table column (which it does)
or, for that matter in the "rows" section (which it also does)