Results 1 to 2 of 2

Thread: Show variables without data

  1. #1

    Show variables without data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    [COLOR=rgb(0, 0, 0)]Dear All, I can't show categories, variables without data in pivot table inserted from data modell. For example I would like to see sales data/every month in a chart, but there is no sales is some of the month.. In "normal" pivot I can choose to see empty cells with no data, but in data model pivots this option is not available. Is there any solution for this? Thank you,[/COLOR]

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Please don't try to use clour tags on your posts. They don't seem to be working and would be of no benefit.

    I suggest that you attach an example workbook
    Hope that helps

    Roy

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •