# Parameterization in Calculated Columns

Given Table 1:

Group |
Name |
Value |

X | A |
2.00 |

X | B |
3.00 |

Y | C |
4.00 |

Creating a new numeric parameter X with a value of 7:

Then adding calculated columns AddOne = [Value + 1] and AddX = [Value] + {X} will result to:

Group |
Name |
Value |
AddOne |
AddX |

X | A |
2.00 |
3.00 |
9.00 |

X | B |
3.00 |
4.00 |
10.00 |

Y | C |
4.00 |
5.00 |
11.00 |

Sample 1

Below is the defined breakdown in a Table visualization:

This Table visualization is showing the grouping of the columns based on the breakdown hierarchy with AddOneSum, AddXSum, AddOneCalc, AddXCalc as Visual Members with the corresponding aggregates and the X value set to 7:

Column |
Aggregate |

Value |
Sum |

AddOneSum |
Sum |

AddXSum |
Sum |

AddOneCalc |
Calculation |

AddXCalc |
Calculation |

Adding an Action Dropdown in the dashboard with a Set Parameter mode:

and given Table 2:

Value |

0 |

1 |

7 |

12 |

will result to these Table values: