group totals

  1. B

    Lookup Formula Equivalent in Powerpivot?

    First-time poster and Powerpivot newbie, so please bear with me. I am looking for an equivalent to the Excel lookup() formula in Powerpivot. I have one large set of data in Powerpivot where I calculate annual invoice volume per invoice among 300,000 rows of invoice data. I have a separate...
  2. A

    Progressive Sub Totals

    The following is a simplified version of a spreadsheet using Microsoft query to populate columns A and B. I need a formula that can be copied down column C that will recognise if the row is a Sub Total and apply the relevant total using the rules below: <?xml:namespace prefix = o ns =...

Some videos you may like

This Week's Hot Topics