Would you be able to share a workbook as twbx so we can give you an answer tailored to your problem?
Still waiting for your suggestions.
I tried 'show hidden rows' too (Analysis -> table layout -> show hidden rows), but its not working.
Thanks in advance.
Sorry about the delay. I was on holiday.
To achieve this you will have to do a bit of "scaffolding", add some extra data to create those missing rows. Follow the steps below and look at the example attached.
1) Create your scaffold data set: In this case your new data set is
You don't even need to create a new Excel file, you can just copy it from above and paste it directly on your Data Source tab (that is why in my case my new dataset is called clipboard_xxxx)
2) JOIN your scaffold data with the rest of your data with a "Join Calculation". The calculation for both sides is only "1". Then both datasets will be joined by 1=1 which basically will append your scaffold dataset to your other data, creating the extra rows.
3) Replace your category field with the category field from your scaffold and make sure to exclude the Null fields created.
4) Create a calculation for your new discount field zn(if [New Category Field]=[Category] then ([Discount]) else 0 END)
That should be all!
Again, sorry for the delay on the reply. Hope you find this helpful. If this answers your problem please mark it as helpful and correct so other users can refer to it.
Did this work for you?