Spacing for report structure

[swebb]

Hi All,

I'm trying to maintain a certain type of format for a finance report, but when I try to organize by index, spaces I believe are causing me some issue. The error I'm getting is that it cannot organize by index for duplicate values. Here's a sample of the structure I'm trying to maintain:

Any info helps. Thanks.

[Idrissshatila]

Hello @swebb ,

Refer to the following videos for building financial reports :

https://youtu.be/PI52ckgezzA

https://youtu.be/J4317R5BvsA

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[swebb]

For each column I've added or removed all white space. E.g., I've added 2 blank characters as Bas suggests in column 1 for Net Operating Income at the end, for the second column I've added 1 blank character at the beginning, and trimmed the third column. I've done this for all values for all columns. So, if something exists in column 1, I've added 2 blank space characters, added anywhere from 1 to 8 in the second column for each row value, and then trimmed third column row values. I hope this makes sense.

[swebb]

Unforuntately, I've seen Bas's videos, and the structuring he suggest does not work. I go to filter out the "null" values to circumvent the issue with the indexing/ordering of the rows, but there are no null values to filter. So, I'm still stuck with the issue of being unable to order the rows.