Sorry my mistake, Price, quantity and value are all part of same Aggregate Fact table with item and Calendar as dimension tables. But here we are using quantity and value as measures while price is used as a pivot column,that's the reason i am having this issue. Thanks Prabhu

How this works as pivot column? Thanks Prabhu

I created a column with formula which is another measure, But how does this work as pivot subtotal?

Thanks Joel, I will try this option and let you know what happened.

Hi Thanks, I will try this, Yes values "5.111", "5.112" and "WAC" are measures. Yes automated subtotals are for everything or nothing. Thanks Prabhu

Hi Thanks for the answer, then can we pass dashboard value to non system session variable as input parameter, this is to say value of session variable is dynamic which is derived from sql, can this sql return value be based on dashboard parameter. Thanks Prabhu