hello all good?
How Can I exluce a specific line of my column ?
as example above I want eliminane the line completely "aplic aut mais"
@LETICIAHELENA There is a filter tool, you can set the criteria to be !Contain([Texto], "aplic aut mais" )
Thanks @Qiu Can you help with one more thing? I need to sumazire the amount below date by date where the S is my entries and H means outflow the bank account. Do you know how can I do that?
also I need separate by column, creates 2 columns with one is S column and the other H column
Hi @LETICIAHELENA ,
You can simply use a cross-tab tool:
@LETICIAHELENA I will also do the same as @martinding 😁
Thanks a Million
And is it possible agroup by the date? I need like just one line for 2023/03/24 with the total amount in "entrada" and " Saida" instead of 3 lines
@Qiu @martinding Do you know how Can I do that ?
@LETICIAHELENA
You can use the Summarize Tool and group by your [Date] column then choose Sum over your other columns.
