I got my project, where source is postgresql. the thing is that I also have button on my sheet, which changes the value for variable vlanguage . In my source table i have table with different columns. depending on variable vlanguage, pivot table should display different columns from initial table. The thing is that button only works if you update sheet or reload data. I think it is because source is said to be postgre. Earlier, when I was using excel sheet, i didnot have this problem. It easily switched from column to column. My question is, how can i fix it?
