This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi all, i have a set of financial management accounts that contain various sub totals and KPi rows that I want to remove so i can be left with the source data only and then go on to create my sub totals in excel later. How do i remove unwanted rows without manually filtering the row title of each specific unwanted row? It seems quite manual to me
It is difficult to answer without seeing an example of the data, but typically with these datasets there is a consistent way to designate a sub-total row versus a source data row. For example, the sub total rows may not have an account number tied to it, so you could do something like [Account Number]!=Null()
If you can give us a better idea of the data that would be helpful!