I'm trying to create a conditional field for getting pivot data - for
example, if it is week 1, it will grab the pivot data for week 1 and the
specfic data of interest. I also want to get the grand total amount, but it
doesn't seem to be working when I try to pull that value even though the
condition is met - how is it referenced in get pivot function?