Home Forums Power Pivot Converting PIVOT TABLES to cube members

This topic contains 2 replies, has 2 voices, and was last updated by  sjhc1177 1 week, 4 days ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #18160

    sjhc1177
    Participant
    • Started: 24
    • Replies: 25
    • Total: 49

    Hi, I’m trying to convert my last report that has a pivot table to CUBEMEMBERS. I would like this so the structure and length can always be the same. Plus my formatting, fonts… will match.

     

    But I have BRAND names that change each time the report is rerun. I don’t want to create Excel formulas to trick the system. I would rather my whole report be the same logical plan.

     

    Below is an example of a table converted. This part will keep changing, any thoughts? (&[APEA10 – CT5458]”))

    =CUBEMEMBER(“ThisWorkbookDataModel”,”[tblInvMaster].[BRAND – MODEL].&[APEA10 – CT5458]”)

     

    Thanks

    #18162

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2580
    • Total: 2587

    You may need to re-think your measures to generalize how they handle the brands that change from month-to-month.

    Difficult to say more unless you can post a small workbook sample that shows how the values change from month to month.

     

    #18163

    sjhc1177
    Participant
    • Started: 24
    • Replies: 25
    • Total: 49

    Hi, I have some sample data.

    Is there a way for me to upload it privately or send you a dropbox link.

    Thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.