% Variance Between Columns
I need to be able to produce a year over year, date over date etc type of report in normal grid-date format. I was looking at the Variance feature in the charts, but doesn't really look like what I need. I looked at the Append Sub Query and it looks perfect, but I'm skeptical from the tutorial that there's any interaction between the 2 columns. Is it possible to create a 3rd column that will perform (ColA-ColB)/ColB to give the % change or variance? I attached a snippet of what it should look like. Thanks much!