Always Select One Field Value

[vardhan1305]

I have some fields in the Pivot Table and i need to always display Kansas value from the State field

ID        Customer Name           state

1               a                              North Carolina

2                b                             Kansas

3                c                              North Carolina

4                d                              New York

5                 e                              Kansas

6                 -                               Kansas

O/P:

ID        Customer Name           state

2                b                             Kansas

5                 e                              Kansas

6                 -                               Kansas

Please help me out.

[jyothish8807]

Hi Harsha,

Check this:

[jyothish8807]

sum({<State={'Kansas'}>}1)

I just put a dummy '1' as i donnt see and values in the data set, you can replace '1' with your actual fact field.

Br,

KC