Home Forums Power Pivot PowerPivot Banding

This topic contains 0 replies, has 1 voice, and was last updated by  brawnystaff 2 months, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #17990

    brawnystaff
    Participant
    • Started: 8
    • Replies: 22
    • Total: 30

    Currently using Excel 2016/PowerPivot and using some Calculated Columns to create some “bands” for time based on two disconnected tables.  It works, but I want all the bands displayed, even band does not have any values for them (should show “0” for them, if none fit criteria).

    What I am getting is just the bands that have values in them.

    See attached spreadsheet.  “Desired Pivot” is what I am looking for, “Actual Pivot” is what I have.  Data is in two worksheets – Data and Legend..

    Any ideas? Thx.

    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.