Adding blank Row after total row

[afontaine]

I am looking to add a blank row if the field Account contains "Total" for better formatting.

 

[Thableaus · Accepted solution]

Hi @afontaine 

I did some trick to get there.

- Add a RecordID 

- Change it to Double Type

- Add a filter to select records where Account contains "Total"

- Add .5 to RecordID

- Use DataCleansing with all options checked to remove everything from these fields

- Union this to the original Dataset

- Sort by RecordID 

- Deselect Record ID.

I simulated an example. WF appended.

Cheers,

[afontaine]

@Thableaus 

This solution works great. Thanks so much. One thing is that when I output it to excel or pdf it is hiding those blank rows anyway to fix this?

[Thableaus]

@afontaine 

This behavior is very weird. I simulated it here and the blank row came out with no problem.

Is there any configuration to do that in your Excel Sheet? Like VBA code or something.

Cheers,

[afontaine]

No VBA code as its just rendering to a temp excel sheet at the moment with similar behavior happening with pdf. I have attached the sample workflow I was working on maybe it is something in the table settings of some sort. 

[Thableaus]

@afontaine 

No idea why it supresses the row. I actually added a browse tool after the Basic Table tool and it's there that the row simply vanishes.

Tried all configurations possible and it ignores rows completely empty, with nulls or whitespaces.

My workaround was to add a "-" instead of leaving rows all empty. I don't know if this would be a good solution for you.

@CharlieS is a master at Reporting Tools. Charlie, could you please shed us some light over here? Does the Basic Table contain this natural behavior?

Cheers,

[danilang · Accepted solution]

Hi @afontaine 

I was able to get the dummy row to display full height by using a formula tool to add a non-breaking space(ALT-0160) to the Account field.  I originally tried with a regular space, but excel hid the row anyway.

Note I had to remove your macro for the workflow, because I don't have it.

Dan

[Thableaus]

Great job, @danilang 

I was out of ASCII characters (tried Vertical Tab, carriage return, new line feed) but I had not tried this one.

You're the man.

Cheers,

[afontaine]

@Thableaus @danilang 

Great work, thanks for all the help