Questions tagged as 'pivot'

I want to divide the revenue by volume into a pivot_table (such as a calculated Excel field), so that the average price per product of each month appears: The code you'd like to do is more or less like this: df.pivot_table (index= "Produt...

I'm trying to create a pivot table that has, besides the general total, a subtotal between column levels and lines as well. The lines I've already achieved through the following function: table = df_consulta.pivot_table(index=["CAT1","CAT2...

I got this code in a question here, to update the dynamics of a worksheet, but when running the macro, it presents error - pt.RefreshTable .    Run-time error '1004': Reference is not valid. (pt.RefreshTable) Private Sub Worksheet_Ac...

Is it possible to make one row of TOTALS per column? The explanation of the totals per line was fantastic and it turned out beautiful in my project. Thank you. My code: SELECT ano AS Ano, CCUSTOS AS [Centro custos], coalesce(...

Good afternoon, I have a big question in my query, I have a table with the following info: Iwouldliketogetthefollowingresult I need the result to be the total amount of (payment forms) per day, divided by period in two columns, M and N....

I have a query where you are doing a pivot and it is bringing the correct records per month, however I would like to validate the amount of records per month that shows only employees who have >= 16 in every month! Today the qu...