Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am filtering my pivot table, with
= if(Dimension1 like 'ABC*',Dimension1)
I get the correct Values when ever Dimension1 starts with 'ABC' , but all the other dimension total is showing at the bottom and I do not wants this,
any idea on how I remove this.
Kind Regards
Razak
Hi,
Check the Suppress when value is null in dimension tab.
I attached a sample image.
Hope its helps.
Iyyappan
Hi,
You can check the supress Null value in dimension tab
Hi,
Check the Suppress when value is null in dimension tab.
I attached a sample image.
Hope its helps.
Iyyappan
convert chart to straight tablee
then go to exression-> select no total
for each expression
convert now to pivot table
in presentation ->uncheck partial sum
hope this helps
Hi dreamer,
just see the attachement, now it show sum if id stating with ABC and not sum of all dimension
I hope this is what you looking for
Thanks & Good Luck
Anant Dubey