AnsweredAssumed Answered

One report, two spreadsheet tables, 2 charts.

Question asked by JamesCain on Sep 5, 2012
Latest reply on Sep 5, 2012 by philmodjunk

Title

One report, two spreadsheet tables, 2 charts.

Post

This seems like this would be simple. I have a Database: Product Name.    Qty.       Price.       Total I want to create a report that shows in table form all products, quanties, etc and summarizes their total" This is not hard and I've done this. Now I want a second spreadsheet/table that uses the total I gathered from the first spreadsheet. Minimum Budget = (Grand Total from 1st spreadsheet / 500) * Percentage {this is a number variable} Average Budget = (Grand Total from 1st spreadsheet / 1000) * Percentage {this is a number variable} Maximum Budget = Grand Total from 1st spreadsheet / 1500) * Percentage {this is a number variable} Then I want two charts on the report, one that use data from the first spreadsheet, another that uses data from the second spreadsheet.

Outcomes