I didn't understand why you created those two calculated fields. I think you are trying to achieve conditional formatting in worksheet. Can you explain what you want exactly? did you get your requirement in that sheet? If possible try to explain your doubt with a sample workbook it will very helpful for understanding problem
Actually i followed the steps from Internet itself.Task is accomplish but i have the doubt why they are using the calculated fields
1 of 1 people found this helpful
The sum(0.0) pill is used to create a "multiple axis crosstab" as described at this link:
The max(1.0) is used on the Size shelf to fill the entire contents of a "pane".
However, for this example you don't need to use a multiple axis crosstab--this conditional formatting can be accomplished without it for a single dimension and value. You can remove the SUM(0.0) pill from the view, and you should be able to get the results you want.
Even i try without sum(0.0), i got the solution. If i want to do color formatting for more than one column then sum(0.0) is prefrred right.
will you please clarify this doubt.
and one more thing we can also use min(1.0) in place of max(1.0).I didnt find any difference.
Will you please explain is there any difference in between min(1.0) and max(1.0) in size shelf.
Thanks Alot Mattew