Lisa Jay

  • Total activity 23
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 4
  • Subscriptions 9


Recent activity by Lisa Jay Sort by recent activity Recent activity Votes
  • Emailing Pivot Widget PDF

    Has anyone been able to find a way to email a PDF of a pivot table. If I email the dashboard the pivot widget does not output all of the rows. I can download the pivot widget to PDF manually and al...

  • left join on date dimension

    Hi I have a custom date dimension table, I need to create a left join so that when I have a date with no orders the date is still output. My current custom date dimension scrip is:   Select Distinc...

  • Weekly Targets and Monthly performance

    We have weekly forecasts for the month but monthly targets and performance. We use excel to upload the forecasts, currently we are just uploading for the current month but the business would like t...

  • Transpose pivot table with date dimension in weeks as columns

    Hi I am trying to transpose a pivot table so that the weeks of the year are columns, and the years are rows but I cannot get the weeks as columns. What I want is this: I can get the following in t...