Return variations of a pattern RRS feed

  • Question

  • Uffff, I have many questions today. 

    Can you use power pivot to return all unique variations of a header/subheader pattern? 

    For examaple in this picture main header would be 1, second header would be 1,2,3; and third header would be Uni, Uni, Blank. 

    I will have 1,000's of Header 1#'s but I'minterested in the unique patters of the third header. How can I do this? 

    Wednesday, November 23, 2016 12:43 AM


  • Click in the pivot
    Select design\report layout\show in tabular form
    Design\sub totals\do not show sub totals
    Design\report layout\repeat all row items

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Wednesday, November 23, 2016 8:07 AM