hi
I have:
![ziabobaz_0-1595431327456.png ziabobaz_0-1595431327456.png](https://community.qlik.com/t5/image/serverpage/image-id/37880iFC43FFEEAECD1665/image-dimensions/516x205?v=v2)
where Result Name is calculated Dimension with unticked 'Include null values'
![ziabobaz_2-1595431432115.png ziabobaz_2-1595431432115.png](https://community.qlik.com/t5/image/serverpage/image-id/37882i96D567C4087BFFFE/image-size/medium?v=v2&px=400)
and Ad Cost is:
![ziabobaz_1-1595431361133.png ziabobaz_1-1595431361133.png](https://community.qlik.com/t5/image/serverpage/image-id/37881iFC4929C2280D3297/image-dimensions/208x216?v=v2)
I want this:
![ziabobaz_3-1595431509206.png ziabobaz_3-1595431509206.png](https://community.qlik.com/t5/image/serverpage/image-id/37884iC02BD4A107CA47B4/image-dimensions/211x249?v=v2)
But the result in Ad Cost is zero since I unticked null values in Result Name and it seems that TOTAL does not take into account those nulls.
Is there way I can do both 'no null values' with 'total' in Table?
FYI - that's what happens when I tick back Hide null values. Ad cost is correct, BUT there are null values in Result Name which I don't want to see:
![ziabobaz_0-1595432614056.png ziabobaz_0-1595432614056.png](https://community.qlik.com/t5/image/serverpage/image-id/37887i0E14EDD236A10A1F/image-dimensions/452x219?v=v2)
Thank you