Pivot Table Rows Section Entries Aren't Shown Side By Side At On The Pivot Table

For the False to show blank you need to change the IF function. You did not put anything in the false part of the formula so it shows FALSE then

change put "" in the false part to show blank

=IF([@Date]<>"", [@[Payment Direction]],"")

you need to do that for both columns (year and month)

For the pivottable you need to change the design to Tabular form. to see columns side by side. See link for full explanation
https://support.microsoft.com/en-us/...e-641133c05a80

A guy I talked could do it without using Tabular Form. (It looks better than Tabular Form) But he didn't explain how he did it.

As you see there are 3 entries in ROWS at the fields section and they are shown side by side in the Pivot Table.

How could he do it?

I get what you mean. I forgot to mention when you switch to tabular form you often also want to remove the subtotals you can do that in the same menu as where you change to tabular. there should be a button "subtotals" choose "Do not show subtotals" and it will look lijke the COPY file you uploaded.

You can also change subtotals showing or change the way they are shown on the row fields, if you search for "subtotals" in the link of my previous post. it will tell you how to.

I don't think you understand.

The example in the link you shared doesn't look like mine at all. I don't understand it.

Maybe they should have put Quarter 1, Quarter 2, Quarter 3, Quarter 4 (as column names) side by side in the Tabluar form there.

May you fix my file and explain how you did it please?

Sorry. Now I understand Tabular Form.



1) As you see on the page (Sheet named Report Row 2) there is 1 more row which are blank are written on the cells before the first row in the table. How can I remove it?



2) On the sheet named Report on the column H formatting is not applied. (See the Sheet named Ledger column P which is custom formatted as mmm)
(It should have shown "nov" the 11th month)
How can I fix it?

When I do what you said then It isn't written "blank" except A2.

However Row 2 is blank. (There is no data)

Data starts on the Row3 (A3).

Is it possible to remove the Row 2. I want Data starts from the Row 2 (A3)?

Thank you very much. It works.